Database Recovery

Hi,
Is there a way to Revover a Sql Server 2000 database in the absence of the backup file(the backup file got overwritten). Does Sql Server do any automatic Transaction logging?
Thanks for any inputThe short answer...you need a dump..

Abd yes sql server is constantly creating transactions for every event (even if they're not fully logged)

What's the problem?

database fall down and go boom?

Check this out:

http://www.sqlteam.com/item.asp?ItemID=11672|||The database was overwritten with some old data and by the time this was realised the backup got overwritten with this old data. There are no transactions logs either. Only a full Database backup taken every day.

Is there any hope of recovering at all?

Thanks|||What's your recovery model set to?

Look at this site

http://www.lumigent.com/|||Lumigent LOG EXPLORER!!!!

Probably the best third party product available for SQL Server 2000
it has single-handedly discontinued the STOPAT clause from the BACKUP statement.

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 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?