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
230 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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I was asked if I could set up a fax machine so that incoming faxes were delivered to people's Exchange inboxes and so that they could send faxes from their desktops without needing to print the document first.  I knew it was possible but I had no id…
Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

776 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