how to revert non-corrupted mssql database with stopat
- by Yisman
i have a good, working valid non-corrupted database in mssql that i want to revert to a point in time
how is that done?
the standard RESTORE command requires a full backup as a starting point, and then log backups thereafter.
i cant understand why this must be done from a backup. if my db is good and the logs are OK, why cant i just revert with a STOPAT from the live logs in the db?
one dba suggested that whenever i want to restore i should THEN make a log backup and then RESTORE with STOPAT. i believe it would work but sounds a little backwards
any better ideas?
thank you very much