Fixed it. The distribution cleanup job was not performing and I was able to run the stored procedure manually.

Sorry. My question is, what could be causing such high disk read i/o's from the primary distribution data file? It is 100 times the amount of the write i/o's and...

Thank you!

Okay, I was successful on a copy of the database using the detach/reattach method. But it did require the database being able to go offline during the process which is...

I created a test database with a secondary data file and that migrated successfully.

I have also backed up the production database and restored it to a renamed copy on the...

Okay, I ran the following query:

USE MyDB

GO

EXEC sys.sp_cdc_disable_db

GO

I am now seeing that the log is 98% free space. I'm pretty sure I can take this from here.

THANK YOU for...

Actually those two jobs are "CDC Capture" and "CDC Cleanup".

It returns a "1". How do I disable CDC? I have two jobs, CDC enable and CDC cleanup.

I really am at my wits end with this.

The results of:

SELECT name, log_reuse_wait_desc

FROM sys.databases

WHERE name = 'dbname'

was:

name log_reuse_wait_desc

CampusVue REPLICATION

And this is after running:

EXEC sys.sp_removedbreplication @dbname = dbname

GO

The results of the helpdb execution are as follows:

namedb_sizeownerdbidcreatedstatuscompatibility_level

CampusVue 266730.13 MBc20008Aug 17 2011Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, Version=655, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAnsiNullsEnabled, IsAnsiPaddingEnabled, IsAnsiWarningsEnabled, IsArithmeticAbortEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled, IsNullConcat, IsQuotedIdentifiersEnabled90

I know that's...

Replication had been failing and has since been removed.

Probably daily. The only reason I go that route is because I actually have some experience with replication, and I have none with creating SSIS packages.

What about using transactional replication to create a subscriber database on the destination server of only the tables I need to run the join query against?

We gave rights to the LocalSystem machine account and it worked.