Have you heard of Central Management Server (CMS)? It supports the "interact with each server in a server group from PowerShell" functionality that I think you are after.

If setting up...

It should say "physical cores" instead of "physical processors." I would set it to 6 for the number of physical cores per NUMA node. If you're still seeing too much...

Tracing the nested cursors in that process made my head hurt a little. If you want to stick with a manual stats update process in T-SQL I would recommend you...

Are you following the steps shown in the Workarounds area of the connect itew I linked to above? There are some restrictions depending on how you set it up.

USE [YourDatabase];

SELECT name,

recovery_model_desc,

log_reuse_wait_desc,

is_cdc_enabled

FROM ...

It may work, just realize that you have given up the notion of centralized management. If the restore fails you will not see it in the log on Server A....

I think where jyuan68 is going, and I agree with checking it out, is that if the login used by the Linked Server on the remote server has execute permissions...

osql.exe is not a good tool to use for new development. It has been deprecated since SQL 2005 was released. If you need a command line query tool use sqlcmd.exe.

That...

SELECT [Name] AS [SSIS Name],

...

David92595 (12/21/2012)

---

yes, we are running in comparison to most sql database a rather small and staic database. I was told that a full backup once a day was...

Would like to know the version of the instance but one other beginning question, have you tried selecting the XML out of msdb.dbo.sysssispackages to see if the XML content has...

Are you from the future? SQL 2008 R2 SP4? Just want to level the set before we dig in.

If your logs grew once, after shrinking them they will likely want to regrow again to the same size due to the normal workload on the server. Adding more disk...

"Enabled" = (Not Disabled) 🙂 , i.e. service start type = Manual or Automatic. I like Automatic so I do not need to remember to start it each time after...

Maybe I am confused...why would you ever be working directly with a job_id to call a job remotely? I would not bother with an extra function or round trip to...