Arthur Fuller
artful at rogers.com
Thu Aug 18 16:22:27 CDT 2005
Consult sp_attach_single_file_db in BOL. It will supply the arguments you need to attach such a database to your server. HTH, Arthur -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of kens.programming Sent: August 18, 2005 1:11 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] Backup/Restore Question Sorry, now that I have read this again, I see that this is not what you were asking for. Ken -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of kens.programming Sent: Thursday, August 18, 2005 10:02 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [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 _______________________________________________ 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com