Back Up and Restore Scripts

• ngkh

  Mr or Mrs. 500

  Points: 531

  More actions

  April 2, 2003 at 7:49 am

  #159288

  How do you write a script to back up and restore a database , however you back up database A but restore in another machine using the name B instead of A?

  how do you write a script in Query Analyzer to do that?

• mybid2003

  SSCertifiable

  Points: 6620

  More actions

  April 2, 2003 at 8:07 am

  #452833

  DUMP DATABASE OLDDBNAME TO DISK='D:\DBA\DBDUMPS\OLDDBNAME_DBDUMP_20030402.DMP'

  GO

  RESTORE DATABASE NEWDBNAME FROM DISK='D:\DBA\DBDUMPS\OLDDBNAME_DBDUMP_20030402.DMP' WITH MOVE 'OLDDBNAME' TO 'c:\test\NEWDBNAME.mdf',

  MOVE 'OLDDBNAME_log' TO 'c:\test\NEWDBNAME.ldf'

  GO

  Hope this Helps!!!

  Regards,

  Murali.

  .