<div>
I tried to use several data recovery software and can't see the DB_A.mdf &amp;&nbsp;DB_A.ldf files that have been replaced/overwritten.... still trying<br />
<br />
Currently in Enterprise Manager, it still showing DB_A, but its content is actualyl content of DB_B, and the files name are DB_B.mdf &amp;&nbsp;DB_B.ldf... No more DB_A.mdf &amp;&nbsp;DB_A.ldf...
</div>


I tried to use several data recovery software and can't see the DB_A.mdf & DB_A.ldf files that have been replaced/overwritten.... still trying

Currently in Enterprise Manager, it still showing DB_A, but its content is actualyl content of DB_B, and the files name are DB_B.mdf & DB_B.ldf... No more DB_A.mdf & DB_A.ldf...

<div>
Hi, you guys are correct, there is no way out since there is no backup for the DB_A for restore... Thank you...<br />
<br />

</div>


Hi, you guys are correct, there is no way out since there is no backup for the DB_A for restore... Thank you...



<div>
<div class="content wysiwyg-content">
Hi, I have a database DB_A running in a SQL Server 2000. And I have accidently restore DB_B against the DB_A and causing the database files (data &amp;&nbsp;log) being overwritten and I have no way to recover it.<br />
<br />
May I know how can I recover/restore the DB_A and without losing its data &amp;&nbsp;log file? This is urgent, any help would be much appreciated!<br />
<br />
Thanks in advance!
</div>
</div>


Hi, I have a database DB_A running in a SQL Server 2000. And I have accidently restore DB_B against the DB_A and causing the database files (data & log) being overwritten and I have no way to recover it.

May I know how can I recover/restore the DB_A and without losing its data & log file? This is urgent, any help would be much appreciated!

Thanks in advance!

Urgent: How can I recover/restore an overwritten database?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.