One of our database have several failures, we cant repair it.
Actually all data and objects are available on the corrupted database.
We are using :
- sql server 2008 R2 (standard edition)
- recovery model : Simple
- compatibiliry level : SQL server 2005 (90)
Shemas replication scripts have been generated (using ssms) and we write a piece of code for migrating data between the old and a new database.
Our problem : We cant stop the old database during the copy.
My question, during the maintenance some data will be written to the old database.
What is the best/simple way to temporaly store this diferencial data for a post maintenance fast reinstatement ?
If there's a best way to duplicate this corrupt database using some tools or other prodcedures, your suggestions are welcome