Friday, February 25, 2011

Backup and restoring Database

This is the command used to take the database Backup from Disk:

BACKUP DATABASE DBNAME DISK='filepath\backupname.bak'


This is the command used to restore the database from backup:

RESTORE DATABASE DBNAME FROM DISK = 'filepath\backupname.bak'