My problem has been resolved thanks for great help

Thanks for the detail reply!

i need to tell you this error occurred for a mint (1:00PM to 1:01) after that it automatically resolved.As i explain more we have 30 databases...

No during password changing I did not get any error it's comes in 2 or 3 monthes last time I got that error in feb 2010 we are using shared...

Thank you very much i got it.

Sorry for miscommunication i more explain assume my production database server crashed for time may database backup on TAPE i have another test server and need to restore database...

thanks for the quick reply we are not going to migration we wanted to test backup using copy command to our new sql server and restore backup get from...

My diff backup size is only between 200 to 300MB.So i can use fullbackup weekly +diffbackup daily plus each 30 mints TLOG backup.

Question is if system crashed i have fullbackup...

Thanks for the reply i clear my words we have two type backup one is legato and second is native backup yes i am taking diff backup as native...

Thank you so much for detail reply.

Can u send me any backup plan sample which give me zero dataloss and recovery time reduce.

Thank for reply.

As i understand we need last fullbackup and all TLOGS for recover point to time in recovery well What is best backup plan which i need to impliment...

Thanks Gill your detail reply.

i have increm backup which i taken sunday 3:00AM there is gap as i explained database has crashed sunday 12:41.Database was open for users after crashed...

Thanks for the detail reply.

i have 20 databases in single instance all databases in full recovery model.below is our backup policy which we are using legato sql backup,

MSSQL: ==> all...