Backup
ALTER DATABASE dbname
SET READ_ONLY;
GO
Backup database dbname
to disk = 'C:\...\dbname.bak'
Restore
Restore database dbname
from disk = 'C:\...\dbname.bak'
with recovery, replace
ALTER DATABASE dbname
SET MULTI_USER;
GO
If the databases are in full recovery model
Backup
Backup database dbname
to disk = 'C:\...\dbname.bak'
Backup log dbname
to disk = 'C:\...\dbname.trn'
with norecovery
Restore
Restore database dbname
from disk = 'C:\...\dbname.bak'
with norecovery, replace
Restore log test2
from disk = 'C:\...\dbname.trn'
with recovery
