Eric Barro
ebarro at afsweb.com
Tue Sep 23 10:01:13 CDT 2003
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