I missed one.

Any input would be greatly appreciated?

I had to stop the Snapshot Agent and Log Reader Agent.

I have to synchronize the snapshot.

Microsoft says to do the following:

1.In Replication Monitor, expand a Publisher group in the left pane, expand a Publisher, and then click a publication.

2.Click the...

I appears that all I have to do is remove the article and then generate snapshot?

The SPID's with a -1 have about 20 entries for the same DPID.

Thanks Jeff!:-)

How do I counter the Trans Logging issue?

I know how to get around it.

If he tries to delete record for 16 years then he is going to have a problem.

Jeff Moden (6/23/2015)

Welsh Corgi (6/23/2015)

He wants to partition 15 years into the First Partition and the current year...

Jeff Moden (6/23/2015)

Welsh Corgi (6/23/2015)

He wants to partition 15 years into the First Partition and the current year...

He wants to partition 15 years into the First Partition and the current year in another partition

Then archive...

What factors should be considered in the Strategy?

He wants to put all but the last Year in a partition and then archive it.

There is a disk limitation with the Transaction...

Thanks!:-)

I did not get the example on the Date Ranges?

Did you see where I posted the records with GROUP BY Year and a record count for each year.

If I create...

They do not want it for performance reasons. They want it to be a way of archiving data.

With the Data being...

Currently there are 3 File Groups. Primary, FG1 and FG2.

FG1 is the default.

What impact does have on creating file groups for the partition, if any?

Here is the data in that CreateDate Column:

CreationDateYearRecordCount

NULL4439

19301

19401

19903

19975880

199863068

199985365

200082985

2001151719

2002255011

2003386974

2004408519

2005525129

2006638583

2007852965

20081262168

20092022856

20102974695

20113285952

20123631320

20134838442

20143982934

2015210

20162

20171

20181

20191

20204

20291

20311

20502

20771

20881

21022

21037

21042

21122

22011

23041

25552

29121

29131

30135

30141

30231

50081

50111

62011

70131

72011

82011

92011