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...

I have doubt..

Log shipping process have been configured on the primary database also transaction logs apply to secondary database instance, then after create new db user in primary instance then...

Thanks for reply..

I try to created new user & login on the secondary server instance, but still facing same issues...not able to create new user on the standby read-only daabase

Error...

1. For the logshipping configuration, Should I remove the existing Tlog backup Job in sql agent? I have deleted existing backup jobs due to mismatch LSN.

if remove existing Tlog backup...

I have tested only LOG SHIPPING with Test server, it was working fine after 2 days watching and monitoring logshipping activity then going to configure production servers.

Please verify and suggestion...

Thanks for reply...

1. Principal database - Primary server

2. Mirror database - secondary server

These two servers data has been synchronized between two servers with HIGH SAFTY mode mirror operations.

I have doubts.

From...