-2

I can take a SQL Server backup to a local disk without any problem, but I now need to backup to a cloud disk or network folder that I can access. What are the best practices to do this?

closed as too broad by Shanky, dezso, Paul White, Michael Green, RLF Jun 15 '15 at 13:03

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • You could start by reading some documents about it - there must be hundreds of them out there. – dezso Jun 15 '15 at 9:03
5

I can't tell you about the cloud disk but when you backup to a network share you can:

  1. Create a network share and assign permissions (I go with full control) to the SQL Server database engine service account (it has to be a domain account)
  2. Backup database to this share like that: BACKUP DATABASE AdventureWorks TO DISK = '\\MyBackupShare\AdventureWorksFULL.bak'

You might have to change the SQL Server database engine service account (local account is default). It's simple. I would recommend using Ola Hallengren's Maintenance scripts though. They give you much more versatility.

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