SQL Server uses a network drive to recover a database

1. The company has more than one virtual machine, because the company provides the machine hard disk is always not big enough ... So I thought of the way to use a mapped network drive for backup recovery work.

The main ways to learn are as follows:

0. First open sqlcmd Start command line interface

1. Open xp_cmdshell to add network drive access:

Method:

Turn on advanced options

' Show advanced Options ',1

After Setup, reconfigure again.

Reconfigurego

To open xp_cmdshell permissions

' xp_cmdshell ',1goreconfigurego

2. Increase SQL Server access to the shared path:

' net use G: \\10.110.6.142\d$ 1qaz2wsx?/user:administrator '

Then use SSMs to recover.

The ability to access the specific path.

SQL Server uses a network drive to recover a database