Partitioning Archives - SQLServerGeeks

SQL Server 2016 – truncation of specific partition

May 3, 2016May 2, 2017 - by Prince Rastogi - Leave a Comment

Hi Friends, Till now we have seen various new improvements in SQL Server 2016. In my previous blog posts, I had explained Trace Flag 1117 and 1118 related changes. Today I …

SQL Server

SQL Server Replication Archiving partitioned and non-Partitioned tables (Without removing the articles from the publications)

January 22, 2012October 8, 2014 - by Abhay Chaudhary - 8 Comments.

Hi Friends , Sometime back, there was a request on the MSDN forums where the OP wanted to archive the replicated partitioned tables in the publisher database . I think it …