another option would be to create a job to execute the package, but not schedule that job. Then you could build a command string (@sql) within the proc to...

I don't know of any out-of-the-box mechanism for what you seek, and if there is one built-in, then I really want to know about it, as well.

I may be leading in the wrong direction because I'm not understanding the "system" you are talking about, but if the "bu" file is like any other sql backupset, then...

Are you asking about restoring a chain of transaction log backups?

I would recommend as part of your final verification that you failover all instances to Node1 and check the @@version of all instances, failover all instances to Node2 and check...

I'm just curious, is this to alleviate the number of requests that a DBA has to handle for a lower environment like Development? Maybe I'm just missing something (which...

Only one quorum

And be sure to execute the following, if adding the user to the master database roles was not your intention:

USE [master]

GO

EXEC sp_droprolemember N'db_datareader', N'N'S602561DC4EW31\GPWebUser'

GO

EXEC sp_droprolemember N'db_datawriter', N'N'S602561DC4EW31\GPWebUser'

GO

The D: drive can only belong to one cluster group. You need a new cluster group for a new instance, and that new cluster group must have its own...

Each instance must have its own group, with its own disk resources.

Having multiple instances in one cluster group, even if possible, would be a very bad idea, because if one...

Colin Lam (2/2/2009)

---

The log file don't grow as large as the datafile because we do log shipping (to our DR site) every 20 minutes, so I am assuming this keeps...

The tables are being used as part of a business process. The table needs a row for each of these steps that are part of a server build process....

Well, I have no idea if this is the best thing to do, but this seemed to accomplish what I wanted. This is probably the least efficient query ever...

Here is the proc I have so far, inserting only one row into the ServerStatus table, with the basic server information from Server_Master. How do I get this specific...

Have you reviewed the logs in the following (or similar) location?

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG