[dba-SQLServer] Backup/Restore Question

Clay,

You would right click on a database, select "All Tasks" and "Restore
Database".  First thing I like to do so that I don't forget is to change the
database name in the drop down labeled "Restore as database:" to the name I
want to give it.  Then, select the radio button on the General tab labeled
"From Device".  The General tab will change with this selection and you will
need to click on the button labeled "Select Devices", at which point you
will need to drill down to the location of your backup file.  Then you need
to go to the Options tab and change the Move to Physical File Name to an
appropriate path for it to create the new mdf and ldf files.  I always like
to check the "Force Restore over existing database" checkbox, but that is
just me.

Hope this helps

Ken

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Clay
Passick
Sent: Thursday, August 18, 2005 9:44 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Backup/Restore Question

Hi to all
 
I am trying to restore a database from a server file backup.  I do not
have a backup through SQL Server as it is a database in development and
not production at this point.   Is there a way to take the restored from
backup files of database A 
(A_data.mdf and A_log.ldf) and rename those files as B_data.mdf and
B_log.ldf and restore them to a newly created database B.  I don't want
to restore over this database in development just retrieve a table or
two.  Everything I have tried at this point either errors out or looks
like it will overwrite the original database because it knows that
originally it was database A.
 
Clay
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

-- 
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 8/18/2005
 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.12/77 - Release Date: 8/18/2005