I am sorry - >5GB and predicted partition key which we have configured in configuration table.

When you have lot of budget then we will prefer the consultant, but handling sql 7.0 to till 2017 we need to take over this with being backup and fall...

• This reply was modified 4 years, 7 months ago by  Saravanan_tvr.
• This reply was modified 4 years, 7 months ago by  Saravanan_tvr.

select getdate() + ((1 - DAY(getdate()))) If today is 01 then it wont work to pick first day of month..

Thanks for all swift response I hope we better to go with DB level audit and wait for few months and let us query from the Output file.

Because :...

I am sure this problem begins with datatype , any constraints missing between Pub. DB to sub. DB tables , please recreate the table from Pub DB and ran it...

No error found.. only in Distributor to Subscriber history -- Agent 'Replication1' is retrying after an error, 3 reties attempted, see agent history folder for more details

Transnational replication

Execution Plan or IO statistics of reads and writes must to have a look at in, also please verify what file group u have placed the new table and check...

Thanks Jeff,

Please choose the CDC for selective column audit logs, rather than writing procedure and killing your performance 🙂

Yes I digged previois year history of ddl changes in source table.. that they did not added newinstance or disable and enable technique... but now I cant reproduce it....

But without creating one more instance, previously it added the new column in to CDC tables.. how it was? I cant digest the behavior of CDC?

Hey thanks for the valid suggestions,

But I can say here the Data statistics here...

In 2011 -----> 1.5Crores rows for each 5 tables

In 2012 -----> 2.5Crores rows for...

Or how can we purge the CDC data without any issues... anyone tried before? if yes please let me know your experience's

Yes I tried with all but again it says the below error from

SELECT * FROM msdb.dbo.sysmail_event_log;

Results

1) Exception Information

===================

Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException

Message: The read on the database failed. Reason: Failed...