Issue happened with MOSS 2007
Problem We have SharePoint server 2007 connected to the production environment with the SQL Data base name WSS_Content_P. Due to some technical changes we by mistake triggered the Production Front end to the Test environment Database that is WSS_Content_T . Here the Test database was just the replica of the production database with difference of 2 days. Now after some days we got to know that such a problem has been created. We found that business data of 2 days was missing from the database. Solution : In the End we came to solution to any how sync the two databases. Now we needed the best database comparison tool to check the data from the two database server. Tool Used : VISUAL STUDIO Internal Tool : SQL > DATA COMPARE · Click the Data compare option in visual studio. · Provide the connection to both the databases, one will be source and other will be the destination. · ...