I performed a full backup on a development database (Full Recovery Model) in SQL Server, made some changes, backed up the transaction logs, made some more changes and backed up the transaction logs again.
Now, when I restore the database using WITH STANDBY, it puts the database into a read only mode. I've noticed that the WITH STANDBY option creates an "undo" file. What exactly is the undo file for, what does it contain, how does it work, and what can I do with it? Can I roll back a restore if I have restored one to many transaction logs, or is it just a file that the system needs?
July 18, 2008 6:49 PM
July 18, 2008 7:10 PM