0

I am using SQL Server (2008 to 2016) on Windows. I have multiple servers, with multiple instances for one of them and a lot of databases (Over 1000). All databases are dumped on multiple storage in each server with maintenance plan.

I want to dump all databases on one SAN Volume (different folders)to reduce the number of storage to backup with NetBackup.

Did you see reason to don't do that ? (Network restriction, backup time ...) I imagine do this by change backup directory with network link, maybe not the good way ?

  • You can set a Maintenance plan on every server and choose the same folder. – McNets Nov 16 '17 at 16:06
3

Consider using Ola Hallengren's maintenance scripts. His scripts are community agreed upon gold standard for this type of work. His scripts will break out each server and instance into separate folders for you automatically.

Going to one location is fine. Some companies use a Data Domain which a SAN built for backups. You essentially write to a central network share. Writing to a single location for backups is not uncommon.

Now....some things to consider when doing this

  • network bandwidth to the device you are writing too
  • network bandwidth from the device you are backing up
  • compute power of the device you are writing to

The idea with these items is to think about not overwhelming your backup location. You also do not want to kick off too many backups on one server and use all of the network bandwidth on your server. This would cause timeouts and other client side issues. Maybe break up the workloads by environment. Non-prod starts at 5pm (the end of the developer day), while production starts at 8pm (the end of the business day). This way your backups are not all firing off at all once. You may need to adjust further based on what results you receive.

Test, test and test more with a small subset of servers. Then you can adjust to scale out for the larger subset of servers and databases.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.