Solved

Restore SQL 2005 Database

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

746 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

14 Experts available now in Live!

Get 1:1 Help Now