I am starting to research setting up log shipping with our server. I am thinking I want to use standby mode for the remote server for the things I want to do (Data checks, ect.) What I wanted to know and have not been able to really find a definite answer on is once I create a undo file with the standby mode of restoring the database,
- How large is that file normally?
- Does it grow over time?
- Is it worth it (or even possible) to drop in to NO_RECOVERY mode when I don't need to access the database and switch back in to stand by mode when I am doing a data check?