SQL Server 2012 backs up the database to a shared folder on the network

Back up the database in computer computer1 to a shared folder in Computer Computer2 (ip:192.168.0.130)

Create a shared folder under the F-disk in Computer2 called Dbbackupshare, and be careful to add everyone to the Security tab page.

In Computer1 and Computer2 computers each set up a user, is the Administrator group, the user name and password must be the same,

CMD command line to add a user to the computer, the user name is SQL

Net User SQL 123/add

Add user SQL to the Administrators group

Net localgroup Administrators Sql/add

(Open the Run Window shortcut key is win +r )

Enter \\192.168.0.130 carriage return in the Computer1 run window to see the shared folder in Computer2

In Computer1 's backup device, create a new backup device BackupTocomputer2, \\192.168.0.130\DBBackupShare, save

Computer1 SQL Server Services, login, login identity is the NT service\mssql$ instance name by default, if not changed, at this time back up the database to Computer2, will report no permissions error. (Unable to open backup device ' BackupTocomputer2 (\\192.168.0.130\DBBackupShare\test.bak) '.) Operating system error 5 has occurred (access denied. )。 )

Backup database test to [BackupTocomputer2] with Init

Change the login status to SQL, password 123 save, at this time back up again, you can backup successfully.

SQL Server 2012 backs up the database to a shared folder on the network