there is no kick off full backups and no backup jobs running....

there is no backup jobs at present. and there is no kick off full backups in between the time.

physical_device_namebkSizeTimeTakenbackup_start_datefirst_lsnlast_lsnBackupTypeserver_namerecovery_model

d:\tail.trn0 MB0 Seconds2013-07-03 11:53:43.0005400000002120000154000000021700001Transaction LogQBSRECPU04FULL

D:\Backups\a\a_backup_2013_07_03_115000_8310075.trn0 MB0 Seconds2013-07-03 11:50:00.0005400000002040000154000000021200001Transaction LogQBSRECPU04FULL

D:\Backups\a\a_backup_2013_07_03_114501_4010075.trn0 MB0 Seconds2013-07-03 11:45:01.0005400000001840000154000000020400001Transaction LogQBSRECPU04FULL

D:\Backups\a\a_backup_2013_07_03_114501_5420075.bak1 MB1 Seconds2013-07-03 11:45:01.0005400000001860003854000000020400001DifferentialQBSRECPU04FULL

D:\Backups\a\a_backup_2013_07_03_114000_9340075.trn0 MB0 Seconds2013-07-03 11:40:01.0005400000000980000154000000018400001Transaction LogQBSRECPU04FULL

D:\Backups\a\a_backup_2013_07_03_113503_8269408.trn0 MB0 Seconds2013-07-03 11:35:03.0005400000000530000154000000009800001Transaction LogQBSRECPU04FULL

D:\Backups\a\a_backup_2013_07_03_113503_8269408.bak8 MB1 Seconds2013-07-03 11:35:03.0005400000000990016854000000017100001FullQBSRECPU04FULL

when i run the commands in the article it is expecting parameters.....

yes the database was restored using no recovery and after successful restoration of full backup the database was in restoring mode....

Yes that is the problem. i can see those ones in red color and having an alert in reports . i want to delete them. what is the method...

by the time i select the differential backup in the GUI the script option is greyed out and on left hand top corner displaying 'unable to create restore...

I am using GUI of SSMS 2012 for doing restore operation.

we have one more issue recently.. the table exists in database and the data before 5 hours is not available. As the table has all the data for last 5...

Thanks for your immediate reply..

Thanks Gail .It worked like a charm...

sql server is not starting up.... so how can i make changes.

i have to use alter statement for ldf files as well,that will solve the issue. but how can i...

i tried your suggestion it doesnt help. i am seeing in custom reports ... log shipping status .. and i find the alerts are still there ...

any ideas please.........

i cant see any service accounts i can see only domain user accounts there. do we need to add service acount in security tab