Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • 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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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