Does sql express have the sqlcmd.exe installed? If so, you can use that.

Give this script a try:

http://blog.ola.hallengren.com/

It runs much quicker than the default maintenance plan and is more configurable.

Also, this is good reading, even if you're not using sharepoint:

And you put your disks inside the new group you created, and then selected that group during the install? (yes, probably, but just making sure).

We are using a combination of zabbix, splunk and ssis driven repository. It's not one tool, but perhaps one of them might eliminate a sore spot for you.

zabbix does...

Just use the add/remove programs, it will do everything on it's own.

Wouldn't you want to set 111 to no for the named and 132 to no for the default?

There is a schema mapping function in Compare that will do what the author was wanting (and found).

Just to make sure we're on the same page...

SSCM -> SQL Server 2005 Network Config -> Rightclick TCP/IP - properties-> Click IP Addresses Tab ?

You then change it and then...

Are you wanting a scale out installation - two web servers using the same report database or do you want totally separate servers? The MS article is for doing...

Here is some script I put together from a few sources that will create triggers on all your dbs, create an audit database and setup some some permissions. It...

We also got this same error when our core routers and some switches were down for maintenace. No jobs run, no jobs show failed. What a pain. ...

Thanks for that.

Made a little mod to it to take optional parameters

example call

sp_helpbackups 'sql_dba', 'D'

or

sp_helpbackups

ALTER PROCEDURE [dbo].[sp_helpbackups]

@MYDBNAME VARCHAR(50) = null,

@BACKUPTYPE CHAR(1) = null

AS

SELECT sysdb.name,bkup.[name] AS FileName, bkup.description,...

Hi,

I'm having the same issue on a cluster and I think it has to do with the fact that you cannot connect to a cluster using 'localhost'. Try...

Does the additional instance use its own IP and Network name?

How is the difference between the two types then signified?...