Hi Andrey,

 

That looks pretty good, it at least gave me something to go on.  I appreciate it!

We were able to figure out the issue, which turned out to be code based.  One of the reasons it took awhile was partly our fault for not being able...

the server configuration is 20 virtual CPU's and 275 gb of RAM allocated to the sql server (the server has a total of 400 gb configured).

No long running transactions that...

the server configuration is 20 virtual CPU's and 275 gb of RAM allocated to the sql server (the server has a total of 400 gb configured).

No long running...

Hi Steve,

I did try to add the logging to the log reader agent but I never got it to create the output file.

Reviewing your article, I...

Hi!

Thanks for  the reply.

I am using a domain account for the remote distributor, which has sysadmin (dev box).  This account is only used for replication.

Brandie Tarvin (3/15/2016)

---

Leeland (3/14/2016)

---

To get around this, I did have an actual full restore done on another server which wasn't being used at this time so I went through the...

Sorry I have been in an all day meeting...

Yes, I am in the simplest terms stuck in a catch 22, I can find no way of removing the table as...

Hello and thanks for the reply.

The files in that particular filegroup are already listed as defunct, attempting to remove the files yields the following error

Cannot add, remove, or modify a...

Taking a step back...just so I understand you...

you have the new storage provisioned and already attached and available to MSSQL server(s)?

i.e. new drives that are the same size as the...

How large is the publication in question?

How long is your outage window?

Is this server virtual?

In the past I have done something in the following

create a new server named the same...

I rebooted the secondary replica and the issue resolved...would be nice to know if anyone else has ever had this issue.

Try this?

DECLARE @xml NVARCHAR(MAX)

DECLARE @body NVARCHAR(MAX)

SET @xml = CAST((

SELECT

[JobName] AS 'td', '',

[step_id] ...

I am not,...