haha Yeah that was a solution i was thinking about. bUt during work-day i did not want to blow up the our network. Yeah it is working by the way...

Perry Whittle (1/22/2014)

In this case you can fix the missing tran log backups issue by taking a differential backup on the primary...

Hi Perry on secondary the output is

YayinSistemi_Data219269000000023400116

on primary

YayinSistemi_Data219269000000023400116

once i run this query

SELECT d.name,

MAX(b.backup_finish_date) AS backup_finish_date

FROM master.sys.sysdatabases d

...

Hanshi my bad, nobody can delete it accidentally.

ok now i want to know this.

Suppose that i have trn files which are 1.trn, 2.trn, 3.trn

I know for sure that last...

Thanks a lot by the way i guess this is also working

select 'ALTER INDEX '+sys.indexes.name+ ' ON '+sys.tables.name+' rebuild' from sys.indexes,sys.tables

where sys.indexes.object_id=sys.tables.object_id

and

sys.indexes.name is not null