Backup_Restore in SQL

24/05/2011 13:34

--Backup and Restore

--Backup
Backup Database DataBaseName to Disk='Path':

Backup database shan to disk='D:\shan2.BAK'

drop database shan

use shan

--Restore
Restore Database DataBaseName from Disk='Path'

Restore Database MTT from disk='D:\31.03.2006.BAK'