Wednesday, December 25, 2013

Simple copy dtabase script in sql server 2005

BACKUP DATABASE blah
  TO DISK = 'd:\blah.bak'

RESTORE DATABASE blah_blah
  FROM DISK = 'd:\blah.bak'
  WITH MOVE 'blah' TO 'd:\databases\blah_blah.mdf',
  MOVE 'blah_log' TO 'd:\databases\blah_blah.ldf'

No comments:

Post a Comment