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
231 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 143

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

To effectively work with Diskpart on a Server Core, it is necessary to write some small batch script's, because you can't execute diskpart in a remote powershell session. To get startet, place the Diskpart batch script's into a share on your loca…
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

856 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