We have had a hardware failure on a SQL server 2005 box. We back up the box on Backup Exec 11D, but unfortunately didn't know to create a .bak file within SQL before the failure. We have found another server running SQL 2005 - is it possible to recover from tape? Any suggestions honestly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Failed server with SQL instance
- Thread starter lizzied
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
Probably not. SQL Server locks the database files while it is running so other process can't access the database files, this includes the backup software.
You can check the backup and see if the mdf and ldf files exists on the backup. If they do exist you can try and restore them, then attach the database to the SQL Server and see if it is able to recover the database.
The odds are against you though.
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)
My Blog
You can check the backup and see if the mdf and ldf files exists on the backup. If they do exist you can try and restore them, then attach the database to the SQL Server and see if it is able to recover the database.
The odds are against you though.
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)
My Blog
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question