It is purely based on your environment. This include the hardware and other resources. I suggest to create some benchmark data like what is the resource utilization, user connections etc....

Thank you all; for participating in the discussion.

Glad to see lots of discussion around. However didn't notice that this question was asked earlier. Thank you for pointing out.

Cheers!

Good question Igor, thanks.

Also when designing SSIS package you can define action if step fails take this action if step successful take this action to control the steps.

HTH

Hi JR,

Usually this kind of error occured when the ISO image of SQL Server in CD or download is corrupt. It is quite possible if anyone download from net they...

Pl. refer following link for details:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/6d46e537-f9d8-4b42-aacb-817550393b92/adding-columns-to-article-in-transactional-replication-without-reinit?forum=sqlreplication

HTH

Good One, thanks.

50K jobs Great!!! Nice to see the capability of SQL Server to handle this much jobs with ease 🙂

Definitely restoring MSDB in different version is not a good idea. You...

Thanks Steve, fun question make me happy 🙂

Easy one.

Recompile the query plan could resolve the issue.

Jeff, love to read the questioner you have asked? This reflect the experience you are carrying. Simply superb!!!

Cheers,

FM

Could be the Full backup of those 2 database was not performed? And when full backup job completed diff backup also successful?

OR

might be the issue of stale query...

Yes, easy one. Thanks Steve.

Easy one.