Hi

We have been looking for something like that...will it be possible to share your knowledge with us 🙂

To be alerted when logs are full,or tempdb is full, etc....

Thanks in advance

A

Thanks for your reply Paul

Its a 3 phase plan we are going through.1)First put db in single-user mode.2)Then switch off the system and 3)then decomission the system.

We cant disable SQL...

Hi All

This is all well, but isnt there a script that loops through all the jobs and disable them all at once.

Thanks in advance

Hi David

I will try, thanks.

My issue has been resolved. I'm doing a full backup everyday, with my log backups every 30 minutes.

And yes I got more disk space....

Hi All

Thanks for your replies. Much appreciated.

David Naples i do like your DR approach. Is it possible for you to issue your SQL script? 🙂

Sounds like something all of...

They are doing large bulk inserts, so we need to make use of Bulk-logged Recovery. So to recover the database to the end of last transaction log backup.(what I meant...

Hi Andras

Thank you for the reply.

It should be point in time. The time (how long the backups take to complete). My backup is running since this morning 3:30. just to...

Hi there

Thanks for the reply.But can you be a bit clearer. Can you perhaps guide me into the right direction?

Thanks

A

Hi

Seems like I called the same procedure in the usp__Failed_Logins proc

😉

I do however get the following error when I execute the linked server script:

Could not process object 'master.dbo.usp__Failed_LogIns'. The OLE...

Thank you all for your replies. Much appreciated

Sorry...

Let me rephrase... are you using a third party backup tool other than using SQL Backups?

And at wat time do your backups run?

Are you making use of SQL Backups?

Are you using a third party tool other then a SQL Backup?

Are you using SQL Backups?

Hi

Thank you all for your replies.

I do have another problem though, when I'm importing this file, I get the error :

Data Conversion failed: The data conversion for column "Date" returned...

Hi

I've saved my packages when I ran the wizard, but I can't see it?

Anchelin

Hi All

Thanks for your replies. However I want to do this via the Import/Export wizard. I have seleted every possible option there is, but no luck...

Anyone please?