Solved

Restore SQL 2005 Database

Posted on 2011-09-13
5
344 Views
Last Modified: 2012-05-12
Hello All,

     I have a client with a tough one here.  They have a SQL server that was running for some time.  After the So. Cal power outage they ran into problems with the server as a few drives have fried.  They replaced those drives and since the Raid was toast freshly installed Windows 2003 and SQL server 2005.  The server is setup with a C: partition of 20GB and the rest of the local drives E: partition of 466GB.  They also have a SATA raid box that connects to the server as drive F of 4TB.  This was used to get the backup files of the database they had on the server.  Well I was going to help them restore the database but I noticed the size of the database backup .bak file alone is 3.6TB.  NOt sure why this file is so large and how I can recover.  Any thoughts?
0
Comment
Question by:bobohost
  • 3
  • 2
5 Comments
 
LVL 5

Accepted Solution

by:
warddhooghe earned 500 total points
ID: 36532971
3.6Tb sounds huge, but the backup job (maintenance plan) might have been set to append each backup to the same .bak file.
Suggest you run the restore wizard and see if you can select the latest backup.
right click > All Tasks > Restore Database > From device > Select Devices > Add your .bak file. Click OK. Click the Options tab. check paths and file names to restore to, etc
0
 
LVL 6

Author Comment

by:bobohost
ID: 36533055
Ok I went in to the SQL Mgmt Studio and followed above.  Will it just try to restore the last backup or will it do that on it's own?
0
 
LVL 5

Expert Comment

by:warddhooghe
ID: 36533157
i would expect a list of all backups inside in that .bak file allowing you to select the one to restore.
recommend trying to restore it into a new empty database, so you dont overwrite anything you dont want to loose.
0
 
LVL 6

Author Comment

by:bobohost
ID: 36533161
Yeah I just went ahead and restored to a new blank database but I didn't see any options.  I just had the check box to restore.  It's in process right now.  I'll post what happens.
0
 
LVL 5

Expert Comment

by:warddhooghe
ID: 36533302
its for mssql 2008 but looks very similar in 2005. should be a "backup set" select-able on the general pages, right after selecting that .bak file in the wizard. (if this is a one file with multiple backups inside)

http://msdn.microsoft.com/en-us/library/ms177429.aspx
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Event-ID 3001, 3011 - LoadPerf - Windows Server 2003 14 62
SQL Query with Sum and Detail rows 2 54
Sql Server group by 10 44
SQL Error - Query 6 41
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question