you would use the no_truncate option if you were trying to recover a damaged database where the log file was still intact. The no_truncate option would backup the tran log...

check out the backupfile table in msdb

just to be sure, put

use master

go

before the restore step

if your company does not have proper change management procedures and software to back it up (i,e remedy) you have a problem. I would not apply ANY change to a...

if you do a search on 'DTS backups' you will find a script that will back each dts package up to a seperate structured storage file. (basically the script from...

could this one user have had 'deny' permissions explicitly set in sql server?

Carlos, many thanks most useful.

Another approach I was comsidering was stored procs that alert whenever a sqlagent job or DTS package is created/amended so I can ensure they are updated...

maxdop = max degree of parallelism. To check can use sp_configure or in EM right click server, check properties, under processor tab you have parallelism, if use all processors is...

time to start archiving then.................

shannon, it is safe to delete the registration of the server in enterprise manager as this is only a client conection the sql instance and not the instance itself. Then...

sorry, once you have recovered the secondary no more tran logs can be applied to it and it is out of synch. You have no choice but to a do...