Solved

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

Posted on 2013-01-25
3
228 Views
Last Modified: 2013-01-31
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
Comment
Question by:tommym121
3 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38822037
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
 
LVL 12

Accepted Solution

by:
Sandeep earned 500 total points
ID: 38822700
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
 

Author Closing Comment

by:tommym121
ID: 38842404
Thanks
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now