thanks barsuk

If ur not at ur desk, how would u know ur database is in suspect mode. We need some sort of script that will alert us via email or text...

thank you very much....just a question, i want to schedule the backup to run everyday, I want the retention period for the backups to be 2 days...how do I do...

thanks, just one more problem, its not displayed the date. It should have the name of the backup and the date should be displayed next to the name. At the...

Its giving me an error, "Incorrect syntax near '='."

Thanks, but my problem was solved a long time ago.

This was the solution to the problem

RESTORE DATABASE [DatabaseName]

FROM  DISK = N'\\[ServerName where backup is saved]\MSSQL\Backups\Folder\Backup.bak'

with REPLACE , ...

I have a databases that are not being backed up. The SA told me that I should not worry about backing up the database because the data is static.

I was...

yes i did, and i get the error that i posted above 

Hi there,

I am still getting the same error:

0x80028019 ODSOLE Extended Procedure  Old format or invalid type library. NULL 0

The error is displayed in different columns names. The stored proc that i am using...

Hi

I took the code from the msdb and just took some of the code out. and created new tables and do not drop them at the end of the script....

thanks alot

thanks, but i already figured it out.

Regards

IC

the problem has been solved, my team leader informed me that the startup parameters where set to local and this had to be handed over to the NT engineers, i...

Hi there

thanks, the problem was solved, turns out that I received the wrong password. I have another problem though, on one of my servers, I have added a linked server,...

dbareport is the username