Home Forums Article Discussions Article Discussions by Author Discuss content posted by Kenneth Igiri Five Useful SQL Server Management Practices RE: Five Useful SQL Server Management Practices

  • January 18, 2017 at 3:33 am

    #1923367

    Thom A - Wednesday, January 18, 2017 2:56 AM

    Helpful article. I had thought about using a share to back up before, but this article has made me start looking into it finally (while I have the time as well!). I'm interested to see how it affects us. The network guy's eyes lit up though, it seems he doesn't enjoy backing up the files on the SQL Server to tape, they'd much more prefer it if they were somewhere else (naming their Back up server). Hopefully this'll make things a little cleaner for all of us.

    Yes, I also recommend this approach.  But if you're moving to it from a model where all servers have their databases backed up locally, make sure you stagger the backups as much as possible, or it'll all end in tears when all backups kick off at the same time!  That includes transaction logs as well: if, for example, you back up every 15 minutes, schedule some jobs for one minute past, some for two minutes past, and so on.

    John