No log file can be missed as i take backup on bkp device. Also i even tried with keep_replication option but that also doenot work. I recreated the backups and...

Ya. I use NORECOVERY with diff bkp. (corrected above). Further, i can restore file 2 but not 4. While restoring file 4 it gives the same error (as above). Further,...

I recreated backup file and then tried to restore again but this time there is a mismatch between LSN Numbers. What is the reason for this. Pls. guide.

Thanks. When i see the LSN of my TLog bkp, the last 6 doenot match and hence i tried to restore the first files Full bkp - TLog - TLog...

I am restoring this thru GUI interface.

Thanks for such a nice article. Further in day to day tasks i need to create a constraint which will restrict the table field size in 50 k. The field...

"Detect nonlogged agent shutdown" is the error.

Thanks i will try.

Thanks a lot.

Can this package be emailed weekly thru automation. If yes how i will configure the sql agent to send this package for eg. every monday.

sorry..as i am a new dba, i...

Sorry may be i need to me more clear.

The view is a report which needs to be submitted every week. Ya i understand that we can avoid creating stored procedure...