Tail log backup is taken in below ways:
If the database is online follow below syntax:
BACKUP LOG [database name] TO [backup device] WITH NORECOVERY
If the database is offline (example a corrupted database which does not start]
BACKUP LOG [database name] TO [backup device] WITH CONTINUE_AFTER_ERROR
No comments:
Post a Comment