Post reply

sql 2k cluster and database management.

  • July 29, 2002 at 9:54 am

    #78653

    any doing automated maintenance on their sql clusters DBCC checkdb etc. My scripts in 6.5, 7.0 and 2000 basically stop and start sql in order to get any users still in db out, then my scripts put the db's in single user mode and I'm off. This will work with SQL clustering but the caveat being the sql instance will failover to the other node. what can I do with this? appreciate any help.

  • July 29, 2002 at 12:59 pm

    #433574

    thanks, the alter db commands worked well.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply