Remote SQL Server Server Backup Data to Client

xiaoxiao2021-03-06  41

Remote SQL Server Server Backup Data to the client can add a network disk backup device on a remote server: The following example shows a remote disk backup device. The name that starts SQL Server under then must have permissions to the remote file.

Use masteexec sp_addumpDevice 'disk', 'netWorkDevice', '//servername/sharename/path/filename.ext'

The remote database can then be backed up to the local device.

转载请注明原文地址:https://www.9cbs.com/read-71912.html

New Post(0)