Thank you this solution works for me .

Thanks Alan ,

This Database used to be in simple recovery model and I did change it to Full now. I am taking T-log backup...

Thanks Jeff and Everyone for kind suggestions.

here some more details.

Full Backup - Every night

Index Rebuild Every night

T_Log - Every 3 hr between 5am to 8Pm...

hi Guys ,

Working on same error any workaround please?

same query works fine from SSMS ..I get query result in e-mail . But when I am running through SQL job no notification of query result. and Even not showing...

looks like nothing is happening after running job.. query you sent me showing 2 days earlier info only.

Excellent Jeff . thank you so much

Planning to move all User and system Database Data file to one location and log on other drive.

Was able to create mirroring Successfully after creating and giving service account under with SQL Server runs to proper rights.

I read thatnk you Gail.. I got my answer.

Have a good Day

Everything is default configuration.. nothing is changed.. so my ext que is when page level locking is happens if it default row level locking?

there was permission issue with account.. thanks for all your support .. backup is running now on network drive

Thanks a lot Gail . your information always best .

this is the command

BACKUP

DATABASE XXX.bak TO DISK = N'F:\Backup\XXX.bak' WITH NOFORMAT, INIT, NAME = N'XXX_backup_2013_10_10_153518_8403533', SKIP, REWIND, NOUNLOAD, STATS = 10

GO

Its Overwritting with INIT and NOFORMAT Option.

Restore Headeronly showing most current backup file which todays date..

Had Same issue yesterday and i put database in single use mode and ran it again then put it multi user mode. works fine to me