Database Recovery Issue

We had a hard drive crash on one of our servers. There are no backups of the
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). Any
suggestions would be greatly appreciated.
There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.

Database Recovery Issue

We had a hard drive crash on one of our servers. There are no backups of the
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). An
y
suggestions would be greatly appreciated.There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.

Database poster

Does anyone know where to get posters for the
database/objects/infrastructure for MS SQL 2005?Here is the pdf version, this was also in SQL Server Magazine back in
December I believe
http://www.microsoft.com/downloads/...&displaylang=en

Denis the SQL Menace
http://sqlservercode.blogspot.com/|||Thanks it looks great!!!!!!!

Database Overwritten

We run SQL 2000 SP3a. I restored both DB and LOG files and re-attached the
database and all went well. However, this database has been overwritten
somehow. We definitely have not restored any further files from tape.
The "Date Modified" has been changed on the DB and LOG files. At this time
the SQL Server Logs show "Process ID 54 killed by hostname MYSERVER, host
process ID 3740", followed by "Starting up database 'MYDATABASE'", then
"Analysis of database 'MYDATABASE' (8) is 100% complete (approximately 0 more
seconds)", then "Error: 15457, Severity: 0, State: 1" and finally
"Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.."
We have no Database Maintenance Plans in place. Our backups our taken by
CommVault Galaxy and this shows no restores. I need to find out what has
happened. Can anybody help?
My guess, from the messages, is that someone ran sp_detach_db and then sp_attach_db. But, AFAIK,
there's no more logged that what you have now...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Gerrry" <Gerrry@.discussions.microsoft.com> wrote in message
news:464F2B26-54FC-4C36-8F71-E2450B0B6559@.microsoft.com...
> We run SQL 2000 SP3a. I restored both DB and LOG files and re-attached the
> database and all went well. However, this database has been overwritten
> somehow. We definitely have not restored any further files from tape.
> The "Date Modified" has been changed on the DB and LOG files. At this time
> the SQL Server Logs show "Process ID 54 killed by hostname MYSERVER, host
> process ID 3740", followed by "Starting up database 'MYDATABASE'", then
> "Analysis of database 'MYDATABASE' (8) is 100% complete (approximately 0 more
> seconds)", then "Error: 15457, Severity: 0, State: 1" and finally
> "Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.."
> We have no Database Maintenance Plans in place. Our backups our taken by
> CommVault Galaxy and this shows no restores. I need to find out what has
> happened. Can anybody help?

Database Overwritten

We run SQL 2000 SP3a. I restored both DB and LOG files and re-attached the
database and all went well. However, this database has been overwritten
somehow. We definitely have not restored any further files from tape.
The "Date Modified" has been changed on the DB and LOG files. At this time
the SQL Server Logs show "Process ID 54 killed by hostname MYSERVER, host
process ID 3740", followed by "Starting up database 'MYDATABASE'", then
"Analysis of database 'MYDATABASE' (8) is 100% complete (approximately 0 mor
e
seconds)", then "Error: 15457, Severity: 0, State: 1" and finally
"Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.."
We have no Database Maintenance Plans in place. Our backups our taken by
CommVault Galaxy and this shows no restores. I need to find out what has
happened. Can anybody help?My guess, from the messages, is that someone ran sp_detach_db and then sp_a
ttach_db. But, AFAIK,
there's no more logged that what you have now...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Gerrry" <Gerrry@.discussions.microsoft.com> wrote in message
news:464F2B26-54FC-4C36-8F71-E2450B0B6559@.microsoft.com...
> We run SQL 2000 SP3a. I restored both DB and LOG files and re-attached the
> database and all went well. However, this database has been overwritten
> somehow. We definitely have not restored any further files from tape.
> The "Date Modified" has been changed on the DB and LOG files. At this time
> the SQL Server Logs show "Process ID 54 killed by hostname MYSERVER, host
> process ID 3740", followed by "Starting up database 'MYDATABASE'", then
> "Analysis of database 'MYDATABASE' (8) is 100% complete (approximately 0 m
ore
> seconds)", then "Error: 15457, Severity: 0, State: 1" and finally
> "Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.."
> We have no Database Maintenance Plans in place. Our backups our taken by
> CommVault Galaxy and this shows no restores. I need to find out what has
> happened. Can anybody help?