Restore SQL 2005 Database

Posted on 2011-09-13
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?
Question by:bobohost
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Accepted Solution

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

Author Comment

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?

Expert Comment

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.

Author Comment

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.

Expert Comment

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)

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

635 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