Backup Database

From Logic Wiki
Revision as of 14:19, 23 October 2014 by Macrop (Talk) (Created page with "Category:SQL == To Backup from the command prompt == SqlCmd -E -S ''ServerName'' -Q "BACKUP DATABASE [DatabaseName] TO DISK='D:\Backup\Bck.bak'" == To Resore database...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


To Backup from the command prompt

SqlCmd -E -S ServerName -Q "BACKUP DATABASE [DatabaseName] TO DISK='D:\Backup\Bck.bak'"

To Resore database from Command Prompt

SqlCmd -E -S ServerName -Q "RESTORE DATABASE [DatabaseName] FROM DISK='D:\Backup\Bck.bak'"

From Query Window

BACKUP DATABASE [DatabaseName] TO DISK='D:\Backup\Bck.bak'

Retrieved from "https://logicwiki.co.uk/index.php?title=Backup_Database&oldid=724"