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
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.