|
pankajum
Starting Member
India
2 Posts |
 Posted - 11/10/2011 : 08:05:39
|
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 FilesMicrosoft SQL ServerMSSQL.1MSSQLBackup
SqlCmd -E -Q “Backup Database MyDB To Disk=’%LocalFolder%MyDB.bak’”
XCopy “%LocalFolder%MyDB.bak” “\192.168.16.55BackupDatabases” /Z /V
DEL “%LocalFolder%MyDB.bak”
Pankaj Kumar |
|
Correct the Syntex for : Backup Locally and then C
