Home > SQL > Restore BAK file on MSSQL 2008 R2

Restore BAK file on MSSQL 2008 R2


alter database db1
set single_user with
rollback immediate
restore database db1
from disk ='d:\db_backup_2012_11_20_235900_7740000.bak'
with move 'db_data' to 'i:\db.mdf',
move 'db_log' to 'i:\db_log.mdf',
replace
Categories: SQL
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: