Forum Replies Created

Viewing 4 posts - 136 through 140 (of 140 total)

  • RE: Backup & restore procedures for msdb

    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...

    Brad M. McGehee
    DBA

  • RE: Dealing with Backup that is taking days to complete

    You can't run two backups at the same time. This is what is causing your current issue.

     

    Brad

    Brad M. McGehee
    DBA

  • RE: Dealing with Backup that is taking days to complete

    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...

    Brad M. McGehee
    DBA

  • RE: Performance ?

    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,...

    Brad M. McGehee
    DBA

Viewing 4 posts - 136 through 140 (of 140 total)