How to back up SqlServer 2008r2 to a shared disk

This article will explain in detail how to back up SqlServer 2008r2 to a shared disk. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Background: there is not enough local space for backing up a SQLServer library today; I just want to back it up to a shared disk. Write down the memo.

Environment: SQLServer2008R2_x64

The steps are as follows:

1. Enable xp_cmdshell if xp_cmdshell is not enabled, perform the following enablement: EXEC sp_configure 'show advanced options', 1 exec sp_configure' xp_cmdshell', 1

two。 Create the mapping exec master..xp_cmdshell 'net use Z:\\ 10.139.101.181\ D$\ Backup 123456 / user:10.139.101.181\ administrator' Note: server password 123456; user name is administrator

3. Backup database

You can choose command backup

Backup database test to disk='\\ 10.139.101.181\ D$\ Backup\ test.bak' with init

It can also be operated directly on the interface, and the backup interface can directly see the shared directory Z disk.

This is the end of the article on "how to back up SqlServer 2008r2 to a shared disk". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.