In Publication properties, it is best to mark it as "Subscriptions never expire".

Also you could execute the below to bring it back to normal state.

USE distribution

GO

Update [MSsubscriptions]

Set [status] = 2

where...

Hey Jeff,

You managed to bring life to a post that is a decade old? 😛

This is how I see it. PASS has become a corporate machine. I was very much involved in PASS for a very long time. In the beginning everything was peachy....

You could always use Standard edition for subscriber which is not that expensive for reporting and use Transactional replication.

You can take a look at sys.sp_identitycolumnforreplication

There are times the queries take bad plan if the IN parameter datatypes does not match the table definition. Do you have any control over the code in the OLTP...

Thank You. This is the best suggestion I have so far and makes sense. I have been asking it on twitter too and did not get any good suggestion.

1 Mil is a pretty good number. When we look at Sentry we do see around that range write bytes on our Env.

On another note, will you be at...

Under what user is the service running? Under your name or a service account. If the service is not running under your account, it does not matter whether you have...

Did you take a copy of the files before you deleted?

Like Gail asked, did you check the permission before you deleted those files?

What is the user under which the SSIS is running? The target server and host server, does it also have the same username and password?

You can make it granular...

You could give just execute permission on sp_help_jobhistory (They need to know the name of the job I think)

Or give them select permission to sysjobhistory...

Give access to the role SQLAgentReaderRole is MSDB Database.

Since all the disks are SSDs we did not think of separating the TxLog into a separate LUN. We have seen ASYNC Network IO Waits but never Disk IO. That...

It wasnt log back up for sure. This happened at 11:44. Our Log back up runs at 11:55. The batch request per second never went more than 1600 per sec...