Yes, Mr. Perry you are right, TransactionLog file was deleted at secondary server...The last restored Tlog on 29-Dec-2012 at 4 AM, LS tried to apply next LSN but it was...

Pl. Let me know, In export wizard FK, PK and constraints does not come to destinaton database..Is it correct?

deleted all records BETWEEN '2012-12-14 00:00:00.000' AND '2012-12-15 00:00:00.000', specifytime period...Not for whole table data.

After exporting data into all tables then we can not recreate FK relationship to the table.

Instead drop and recreate FKs, I did disable all the constraints then export data to...

Thanks Mr.opc.three , It was working fine...with Merge delete statement

sorry for late reply..

export data into BC_ShiftSummaryInfo table some duplicate data was inserted during that time period.. I want delete 3377 duplicate records on BC_ShiftSummaryInfo

Table structure - [BC_ShiftSummaryInfo]

CREATE TABLE [dbo].[BC_ShiftSummaryInfo](

[SS_ID]...

I want delete table on BC_ShiftSummaryInfo

Source database - data is available for all tables...

Generate Script source database and create newdatabase with another name and all other structure and PK, FK ,Identity every thing same as...

ok, at the same time 12:00 Database full backup also running, should I change the full backup time 12:15 AM, and let it be leave Tlogbackup every 30 mints?

yes.. you catched me,, this particular table having consistancy error due to logical HD block courrpted..

so, Im trying to export to another table but export is failed due to consistancy...

On Error log mention the different message during export data to another database on same server

Error: 7886, Severity: 20, State: 1.

Message

A read operation on a large object failed while sending...

I came to know database backup failed due to cycle error for reading MDF file...

I thing the only way to Run dbcc repaire_allow_data_loss command, Becuase I do not have Tlog...

Thanks for reply ...

I have last 5 days backup file....But user side they want current data as on date today...If restored Last day backup today data will not be available?...

Thank you ..&..working fine:-D

yes..Thanks

user apperaing in secondary instance database by atuomatically during restore log shipping process..But it won't connect the application due to login is not apperaing under security->Login, Does we need...