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_name bkSize TimeTaken backup_start_date first_lsn last_lsn BackupType server_name recovery_model

d:\tail.trn 0 MB 0 Seconds 2013-07-03 11:53:43.000 54000000021200001 54000000021700001 Transaction Log QBSRECPU04 FULL

D:\Backups\a\a_backup_2013_07_03_115000_8310075.trn 0 MB 0 Seconds 2013-07-03 11:50:00.000 54000000020400001 54000000021200001 Transaction Log QBSRECPU04 FULL

D:\Backups\a\a_backup_2013_07_03_114501_4010075.trn 0 MB 0 Seconds 2013-07-03 11:45:01.000 54000000018400001 54000000020400001 Transaction Log QBSRECPU04 FULL

D:\Backups\a\a_backup_2013_07_03_114501_5420075.bak 1 MB 1 Seconds 2013-07-03 11:45:01.000 54000000018600038 54000000020400001 Differential QBSRECPU04 FULL

D:\Backups\a\a_backup_2013_07_03_114000_9340075.trn 0 MB 0 Seconds 2013-07-03 11:40:01.000 54000000009800001 54000000018400001 Transaction Log QBSRECPU04 FULL

D:\Backups\a\a_backup_2013_07_03_113503_8269408.trn 0 MB 0 Seconds 2013-07-03 11:35:03.000 54000000005300001 54000000009800001 Transaction Log QBSRECPU04 FULL

D:\Backups\a\a_backup_2013_07_03_113503_8269408.bak 8 MB 1 Seconds 2013-07-03 11:35:03.000 54000000009900168 54000000017100001 Full QBSRECPU04 FULL

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