• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • Last Modified:

SQL - How to use a full backup of one SQL server and recreate a database of anther server

I have make a full backup of a database from the sql server on my machine.  I would like to recreate the database with data on a SQL server within a VM.

How do I take the backup and re-create the entire database in my VM?  Please let me know the steps required to do that.  Thanks.
0
tommym121
Asked:
tommym121
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
As you created a full backup of the database, you can copy that file time the VM, and restore your dba from there. You can do that using the GUI, or via the T-sql RESTORE DATABASE statement.
0
 
SandeepSr System AdministratorCommented:
Hi

Please see if this helps you to perform the Restore at new location.

http://msdn.microsoft.com/en-us/library/ms190447(v=sql.105).aspx
0
 
tommym121Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now