Backup Database
From Logic Wiki
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'
