Carolyn and DNC

Thanks for your prompt reply 😉

Brian,

Our current set up was done by a Consultant no longer with us. I have never set up a SQL Cluster, so this will be our first one. Please advise.

2 instances on a active/passive mode

Need to add a third instance on this active/passive configuration

Yes is SP2.

The History Cleanup task deletes entries in the following history tables in the SQL Server msdb database: backupfile, backupfilegroup, backupmediafamily, backupmediaset, backupset, restorefile, restorefilegroup, restorehistory not the txt...

Backup all databases. We have removed named instances using the SQL server 2000 CD. Same as if you would do an installation but choose to remove the instance.

Figure it out. I was adding the dependy on the wrong group instead that on the SQL Server Group.

Yes to both. The drives U and V are on the same SQL Group which is online and it are a Physical Drives under the resource type column.

It is checked already.

By the way thank you Joe Clifford for your recomendation.

I was able to run the SQLRECON software and create a spreadsheet with the information.   However, some of the clients are showing a...

What about for SQLServer 2005?

Does anyone out there backup the transaction log of the tempdb on a daily bases as a preventive maintenance task?

The initial size of tempdb is 400M so it could have grow as per needed. Maybe I'm missing something because between 400 and 500 there is not a huge difference....

Old Hand :

Our SQL server version is 2000 SP4. Can we create the link from 2000 to Exchange 2003? Can you point to any articles with samples of how to...

There is nothing you can do when you inherent the environment....

We already notify developers that from this point on DTs will be scripted form...