Pain, T. (Tim)
Tim.Pain at sc.akzonobel.com
Tue Sep 23 10:32:59 CDT 2003
John, >From the BOL - To restore a backup from a backup device Expand a server group, and then expand a server. Expand Databases, right-click the database, point to All Tasks, and then click Restore Database. In the Restore as database box, type or select the name of the database to restore if different from the default. To restore the database with a new name, type the new name of the database. Note Specifying a new name for the database determines automatically the new names for the database files restored from the database backup. Click From device, and then click Select devices. Under Restore from, click Tape or Disk, and then select a device from which to restore. If no devices appear, click Add to add an existing backup device or to create a new one. In the Restore Database dialog box, click View Contents and select the backup set to restore. Note This option scans the backup set for the backup content information and can be time consuming, especially when using tape devices. If you already know the backup set to restore, type the backup set number in Backup number instead. Under Restore backup set, do one of the following: Click Database - complete to restore a database backup. Click Database - differential to restore a differential database backup. Click Transaction log to apply a transaction log backup. Click File or filegroup to restore a file or filegroup backup. Specify the name of the file or filegroup. Optionally, click the Options tab, and then do one of the following: Click Leave database operational. No additional transaction logs can be restored if no further transaction log backups are to be applied. Click Leave database nonoperational, but able to restore additional transaction logs if another transaction log backup is to be applied. Tim -----Original Message----- From: Eric Barro [mailto:ebarro at afsweb.com] Sent: 23 September 2003 16:01 To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Restoring SQL Backups John, Here's the restore process I use via SQL Query Analyzer... RESTORE DATABASE nameofdatabase FROM DISK = 'F:\BACKUP\nameofbackup' WITH REPLACE, MOVE 'logicalnameofdatafile' TO 'G:\MSSQL\DATA\nameofdatabase.mdf', MOVE 'logicalnameoflogfile' TO 'G:\MSSQL\DATA\nameofdatabase.ldf' WAITFOR DELAY '00:00:05' --- Eric Barro Senior Systems Analyst Advanced Field Services (208) 772-7060 http://www.afsweb.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of John Colby Sent: Tuesday, September 23, 2003 7:55 AM To: SQLServer Subject: [dba-SQLServer]Restoring SQL Backups If and when I get SQL Server running again (I'm about to re-install it after going back to Win2KSP3), how do I get the backup files back in to SQL Server. It looks like SQL Server keeps the location and names of the files inside the database or something. IOW, there's no "browse for file" function that I can find. I have the data out in files on my disk (with NO extension!!!) so I need SQL Server to ask me where to go to find these things, display a list of the backup files, and then get the data back into a new database. Alternately, assuming my last failed installed didn't trash it, I need the INSTALL to find and use the existing database that still exists on another directory out on my D: drive. Someone please tell me I haven't lost all my billing data. I'm beginning to panic here. John W. Colby www.colbyconsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com