更正Syntex为:在本地备份，然后复制到网络共享 [英] Correct the Syntex for : Backup Locally and then Copy to the Network Share

问题描述

先生，

我有语法可以在本地备份SQL数据库，然后复制到网络共享.

我的本地路径是D:\ db，共享路径C:\ Data和backupfile:dbP.bak
数据库名称:hospitaA

请更正语法以使用它.

语法:

Sir,

I have Syntax to Backup SQL DataBase Locally and then Copy to the Network Share.

My Local Path is D:\db and Share Path C:\Data and backupfile : dbP.bak
DataBase Name : hospitaA

Please correct the Syntax to use it.

The Syntax :

SET LocalFolder=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQLBackup
SqlCmd -E -Q "Backup Database MyDB To Disk=’%LocalFolder%\MyDB.bak’"
XCopy "%LocalFolder%\MyDB.bak" "\\192.168.16.55\BackupDatabases" /Z /V
DEL "%LocalFolder%\MyDB.bak"

推荐答案

正确的语法:

Correct Syntax:

SET LocalFolder=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQLBackup
SqlCmd -E -Q "backup database MyDB to disk='

(LocalFolder)\ MyDB.bak'" XCopy " " \\ 192.168.16.55 \ BackupDatabases"/Z/V DEL "

(LocalFolder)\MyDB.bak'" XCopy "%LocalFolder%\MyDB.bak" "\\192.168.16.55\BackupDatabases" /Z /V DEL "%LocalFolder%\MyDB.bak"

哦，我知道了...

oh, I see...

string sqlConnectionString = "Data Source=(local);Initial Catalog=MyDB;Integrated Security=True";
string sqlCommand = "backup database MyDB to disk='C:\\Backup\\MyDB.bak'";

SqlConnection con = new SqlConnection(sqlConnectionString);
SqlCommand com = new SqlCommand(sqlCommand);
com.ExecuteNonQuery();
con.Close();

// copy file to newtwork location
...

请注意，路径 C:\ Backup \ MyDB.bak 将在您的SQL Server计算机上！不在客户端或其他任何地方. SQL Server只能引用本地驱动器和UNC路径. (但是请不要使用网络共享进行备份.请不要这样做.)
在SQL Server上本地备份，然后将文件移动到网络位置.

希望有帮助.

Note that the path C:\Backup\MyDB.bak will be on your SQL Server machine! Not on the client or anywhere else. SQL Server can only reference local drives and UNC paths. (But don''t use network shares for backup. Just don''t.)
Backup locally on your SQL Server and then have move the file to a network location.

Hope that helps.

这篇关于更正Syntex为:在本地备份，然后复制到网络共享的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！