Viewing 3 posts - 2,491 through 2,494 (of 2,494 total)
We run with SQL Logging all logons, and NT auditing set on for most things. There have been a few situations where people have claimed the DBAs 'must have'...
July 3, 2003 at 6:36 am
#464041
I just leave MSDB in simple mode, but do a full backup of MSDB shortly after my other backups are finished.
I do transaction log backups of the 'real'...
July 26, 2002 at 8:15 am
#433447
A few things to remember...
a) Space may be needed to process the transaction log, as well as database.
SQL Server will always scan the transaction log and to back...
May 27, 2002 at 5:30 am
#429784