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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!