That depends on many factors. Not sure "how long" but you can find out how large the snapshot for the tables will be by running something like:

SELECT pubname...

Out of sheer curiosity; is the backup being done by a 3rd party tool like BackPro, SQSafe, or Lightspeed, etc?

If so, you'll need to kill the actual thread using something...

I store all my SSIS packages in a local folder on each server (I do not deploy them to the package store)...so I can set them up in the Agent...

Is your subscriber online? Or are there any processes blocking your distributor sessions?

Gail, looks like you hit the nail on the head...

In looking through the reporting procedure I did notice a TVF being called (although it really looks harmless and has a...

@Grant - yes it's production (reporting) - and typically I don't do it either but wanted a comparison (its strictly troubleshooting only as I'm not overly familiar with extended events...

This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

I was expecting the raise error function to be thrown if the option was not provided correctly. It only printed the message in the ELSE block.

Can you help me understand...

I'm not entirely sure this will help but found this article [https://ask.sqlservercentral.com/questions/24486/replication-limit-on-number-of-push-subsciptions.html] - I don't think there's an exact limit as much as there's a threshold with "load"

-Hope it helps!

I have written a custom script to rebuild index. But if users choose wrong choice, it is supposed to throw a specific error msg which it does not do.

Please help...

Interesting! I have no experienced this issue.

It could be that you're filling up your files faster than the job is able to pull them out...so it's getting overwritten before...

How large is the dataset being returned? Not saying the network is to blame but returning data locally will always be faster than retrieving it through a linked server...

What does the sp on SQLA do? Just a SELECT? INSERTS? ETC?

Also, what version of SQL?

Awesome! Please be sure to set the autogrowth setting to "In Megabytes", and not "In Percent", and as SQLBill mentioned, ensure the "Maximum File Size" is set to a...

If your database is full, you need to add more space. Rather than making it a manual process, simply enable the autogrowth setting to something "reasonable" (and get rid of...