Solved

Restore SQL 2005 Database

Posted on 2011-09-13
5
333 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

815 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now