Backup MSSQL Using The Command Prompt
|
1 2 |
BACKUP DATABASE [VT-ISMI] TO DISK = N'E:DB_BACKUPSFridayDB-NAME_backup-bat.bak' WITH NOFORMAT, INIT, NAME = N'DB-NAME-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO |
Contents of backup.sql
|
1 |
sqlcmd.exe -E -S SERVER-NAMESQLEXPRESS -d DB-NAME -i E:DB_BACKUPSBatch_FileFriday.sql -o E:DB_BACKUPSFridayFriday_DB_NAME.RPT |
Kategori seçin...
