Viewing 4 posts - 136 through 139 (of 139 total)
The following is not a great solution, but one that works. Instead of relying on backups and restores of MSDB for job fault tolerance, script the jobs instead. This allows...
August 9, 2007 at 11:46 am
You can't run two backups at the same time. This is what is causing your current issue.
August 3, 2007 at 8:37 am
Yes, very definitely, change the recovery model to Full. This not only helps you in regard to automatically truncating the log file, it also allows you to perform transaction log...
August 3, 2007 at 6:30 am
Hi, this is Brad, and I wrote this tip. My problem with views is how they are abused by many developers, especially novice developers. Like any tool in SQL Server,...
March 9, 2007 at 2:43 am