Not sure this is the right forum for SQL 2000 but anyone with adminstrative rights in Windows will have admin rights in SQL Server 2000/2005 by default. You can...

We had exactly the same problem with a cluster using SAN disks. However only one node showed this behaviour and it happened when high I/O occurred and especially around...

You have to take one CPU out or disable it at the BIOS level in order to be compliant with the SQL Server licencing. You are able to use...

When a cluster fails over the servername/ip address remains the same and although any connections to the cluster will have to reconnect after the failover, they just connect as they...

Had something that might be similar - the sql resource came up before the disk resources and therefore sql server couldn't find the database files

Do you mean they failover to the other server? Have a look in the cluster.log, the event viewer and the sql server errorlog. These should show when and...

We use service accounts which incorporate the server name and they all have different passwords. It does make it more secure as previously mentioned but would suggest ensuring a...

... and what? Can you still get in via windows authentication? Are you a sysadmin user? You can change the sa password.

What errors/problems did you have?

The following will do what you want:

Back up the database and restore it with the new name

Detach the database, copy and rename the files and...

I went on a 2008 launch event and they were pushing CDC as an auditing feature. I thought it was more for capturing intermediate changes to data for data...

If you only have a full backup you can only restore to that full backup. So if your database dies towards the end of the day you can only...

Here's some of the processes we went throught to produce a DR plan :

Work out what systems need to be available in the event of a disaster and in which...

I for one would be interested in your thoughts on this technology after you've had your meeting. We are looking into consolidation as well but haven't got as far...

I passed the 70-443 exam first time but was worried about doing it. I think the time per question is about right but I would say read the question,...

From SP1 onwards you don't need to set the trace flag to enable mirroring. The ports are are the endpoints defined on each server.