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.
I can't tell you about the cloud disk but when you backup to a network share you can:
- 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)
- 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.