question

vijay 2 avatar image
vijay 2 asked

Tail Log Backup?

Hello Everyone, I have one problem with backups. I have taken Full backup,Differentail Backup, Transactional Backup.Now I am trying take Tail log backup by selecting the option “Back up the tail of the log, and leave database in the restoring state”. But i am not able to take this backup ,I am getting the error” (Microsoft.Sqlserver.smoExtended). Please can any one explain what is this error and how to reslove this?? Thanks Vijay
backup
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
What's the error? And are you doing the backup through the GUI? What version of SQL Server? What version of the GUI?
0 Likes 0 ·

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
You can't take a tail log backup after you've started the database restore process. You take a tail log backup before you start the restore process. Basically the tail backup is an additional log backup that captures the transactions completed since the last log backup.
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
True. However, given the description under Tail-Log Backups in MSDN, the taking of a tail log is typically a precursor to a RESTORE operation...
0 Likes 0 ·
vijay 2 avatar image vijay 2 commented ·
Hello Grant, I dint start the restoring process, I am trying to take the tail log backup but not able to proceed.
0 Likes 0 ·
ramesh 1 avatar image ramesh 1 commented ·
can use please specitfy the exact error by using xp_readerrorlog.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.