Tag Info

New answers tagged

1

No. Committed transactions modify the contents of the database tables first in the transaction log, then in the data files. Unless triggers or other techniques are explicitly set up upfront, there is no way to recover the values stored in the database before the transaction was committed. In order to do that, you have to restore a copy of the database ...


1

sorry to hear that. Well if u havent trimmed transaction log you can do it. Nice articles how to achieve it: http://www.mssqltips.com/sqlservertip/3160/recover-deleted-sql-server-data-and-tables-with-the-help-of-transaction-log-and-lsns/ How do I rollback a dropped table using log?


0

As someone already mentioned in their reply running DBCC CHECKDB after a restore can be a good practice. This way as a backup is a copy of a db you will verify both backups and restores without any impact on a production DB. You can check this article that describs how to run and/or automate a DBCC CHECKDB after a database restore by automating DBCC ...



Top 50 recent answers are included