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?