bobohost
asked on
Restore SQL 2005 Database
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
recommend trying to restore it into a new empty database, so you dont overwrite anything you dont want to loose.
ASKER
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.
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
http://msdn.microsoft.com/en-us/library/ms177429.aspx
ASKER