Hello,
this is regarding the recover commands.........
I am using this recover commands. And sometimes after the exectution of the few recover command the database is brought online automatically and i do still have other logs to apply.
for eg: backup
1. full backup (DAT_001)
2. Do transactions on the database LOG_001
3. Log backup (LOG_001)
4. Do transactions on the database LOG_002
5. Log backup ( LOG_002)
During the restore/recover, after the LOG_001 is applied the DB is online automatically and I still have the logs to apply (i..e, in this case the LOG_002)
Will the DB be consistent ?
Thanks in advance.