Wednesday, December 23, 2015

Copy SQL Server Database

  • Create a backup on the source SQL Server
  • Copy the .bak file to the destination computer.
  • Note the file name and location of the .bak file on the destination computer.
  • Execute this SQL Query in the destination computer
    • RESTORE DATABASE <YourDatabase> 
      FROM DISK='<the path to your backup file>\<YourDatabase>.bak'

Visit Blue Canyon Software if you need custom software for your business.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.