[dba-SQLServer] Backup/Restore Question

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




More information about the dba-SQLServer mailing list