Solved

Restore SQL 2005 Database

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

947 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

20 Experts available now in Live!

Get 1:1 Help Now