[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1034
  • Last Modified:

Create Copy of Database using Restore Database Option

Question: I would like to create a copy of our Live database for testing purposes. I have been told using the Restore Database is the best option for creating a copy of a database in SQL Server 2000. I am a little nervous because I have not used this option before and I don't want to make any changes to the original database. Could anyone offer the exact steps to take?
Thanks,

Traci
0
SasDev
Asked:
SasDev
1 Solution
 
Chris MangusDatabase AdministratorCommented:
Someone didn't give you the full picture.  You would take a backup of your current production database and then restore it to a different, test server.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
this page covers more or less all the technical issues:
http://msdn2.microsoft.com/en-us/library/ms190436.aspx

now, if you use the graphical interface, you just have to check out 2 important parts:
* ensure that you specify a different database name than the original (this new database name is not required to exist already...)
* in the advanced tab, ensure you specify file path for the restored files that do not clash with the original or any other database (except the one that you restore over, in case it would exist already).

if you do this via TSQL, this translates into using the WITH REPLACE (to overwrite an existing database) respectively the WITH MOVE keywords (to specify the new file locations)
0
 
pssandhuCommented:
What version of SQL Server are you working on?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
aha.. someone did not read the full question :)  
sql 2000...
0
 
SasDevAuthor Commented:
SQL Server 2000
0
 
SasDevAuthor Commented:
Thank you very much angelIII!
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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