[dba-SQLServer]Restoring SQL Backups

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



More information about the dba-SQLServer mailing list