Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Script to compare two DB

Author  Topic 

zero1de
Posting Yak Master

105 Posts

Posted - 2012-10-02 : 06:37:39
Hi,

I have to solve the following problem. We used DoubleTake for the event of a disaster. The database server is mirrored 1:1.

After a disaster event, the original database is gone. The system will switch to the mirrored system. The backup system is identical to the original system.
How can I prove that the backup database is identical in content and data to the prod DB?

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-10-04 : 01:47:14
There are plenty of tools on te market to comapre. Some examples: http://www.red-gate.com/products/sql-development/

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -