Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...
SQL Server Forum / DB Engine / SQL Server / July 2008

Tip: Looking for answers? Try searching our database.

Restore my live database as a test database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Starfish - 31 Jul 2008 16:13 GMT
Hello, I have a live database and a test database on my sql 2000. I need to
restore a backup of my live database to my test database. I want to make sure
I have all the settings correct in Enterprise manager. This is what I have
set.

1. I right clicked on my test database and went to restore.
2. In the restore  database window, I have Restore as database set to the
name of my test database
3. I have Parameters: Show backups of database: set to my live database.
4. At the bottom of the screen I have the restore checkbox checked for
backup set of my live database backup.
5. If I go in to the options tab I have "Force restore over existing
database" checked.
6. I have my original file name set to the live database and my restore as
set to the test database.

In theory, will this take a backup of my live database and restore it over
my test database? I want to be completely sure that it doesn't affect my live
database at all. Thank you
Reply to this Message
Daniel Jameson - 31 Jul 2008 23:40 GMT
Starfish,

I would do it this way:

0) Backup test database, just in case,

1) Drop test database.

2) Right click the live database and choose restore database,

3) Pick live database backup you wish to restore

4) Type name of test database in "Restore as database:" field

5) Click on Options tab.  This will change the name of the database files to
match your test database name.

6) Click OK.

Now when the test database is created by the restore:
a) The master..sysdatabases record will have the timestamp when you made
your copy, if anyone ever asks, and
b) Since you did not check the "Force restore over existing database"
checkbox, you cannot accidentally mess up your live database.

I do this all the time.

Signature

Thank you,

Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org

> Hello, I have a live database and a test database on my sql 2000. I need
> to
[quoted text clipped - 18 lines]
> live
> database at all. Thank you
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.