Yes I'm all for simplicity here.  If I can't get to the primary hardware during an outage I don't have to worry about restoring a final trans log to the...

We use a two-node active/passive sql2000 enterprise cluster.  Initially we had all data on a SAN maintained by a Raging Wire facility near us in Sacramento.  At that time we weren't ready...

I'm planning to use the sql 2000 Enterprise DB maint plan "wizard" to get log shipping started.  Then I'll look into the advantages of doing my own scripting.  Your suggestion...

Thanks I'll check out the "selective reindex" approach.  I'm currently running a test, copying a transaction log backup of about 10GB from our SAN to another sql server -- 18...

In our environment, being a member of the sql sysadmin group does not mean you are a domain admin or even a local admin on the sql server box.  Terminal...

Both data and structure updates.   There is some DBA oversight ( too long a story to tell here )  Bottom line is the person running these are now in the...

Yes, the way it's working right now, database updates ( whether updates,inserts or schema changes ) are QA'd then run in query analyzer by the configuration manager.  First this person...

Sounds like it's time for replication.  I'll have to look into what potential performance hit this would have, but it might be the quickest, least ulcer-prone way to get things...

Sounds like it's time for replication.  I'll have to look into what potential performance hit this would have, but it might be the quickest, least ulcer-prone way to get things...

Old Hand,  if you stop sql on the active node of the cluster, with cluster active, wouldn't it just attempt an automatic failover to the passive node?  Of course with...

Jane, I like that idea.  SANs supposedly fail completely once in a lifetime, but we still have to prepare for that possibility.   So I'm exploring the steps and order of...

Thanks Brian.  What approach does your organization use?  Do you have all data on something like a SAN?  So far I haven't found the syntax and command line parameters...

My problem is that the dt objects appear in some databases as system objects and as user objects in others.   Using Redgate's sql compare, I wind up with a report...

I got some clarification on Cluster Administrator.  Apparently it is just the software that runs in the background and handles failover from one server to the other node in a...

Great discussion and answers.  Now let's focus on the fact that it's a two node active/passive cluster so none of the database files can reside on either of the sql...