This is a discussion on log shipping - synch within the SQL Server forums, part of the Microsoft SQL Server category; --> I have to schedule the automatic restore the standby database for testing backups . The database was already in ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I have to schedule the automatic restore the standby database for testing backups . The database was already in log shipping mode. Up to what point do I need to restore the database without affecting the log shipping sequence? Can we query the log shipping tables for the last scn applied and recover up to that point? Any suggestoions are welcome. Thanks Tram |