Start with Microsoft's web site for SQL Server. There you can find system requirements for each version. That will give you minimum requirements.

-SQLBill

Find the active node, go to Start>Programs>Microsoft SQL Server>Service Manager.

In the Service Manager pop-up, set the server window for your server name, set the service to SQL Server. Down at...

What kind of clustering do you have?

There is active/active and active/passive.

Normally, you have two 'nodes' which are the actual hardware servers (WAS and WDBS for you). Then you have a...

Yes, MS intends to separate the date and time into two different data types. A lot of SQL Server users/DBA/programmers, etc. have apparently requested that change. It makes sense to...

Let's say you need to know all the data from a specific date 2003-10-29.

It's easier to 'pull' that from a column that only has a date. Using separate columns, you...

I talked to my network security person here (lots of experience). He says that the attack isn't a Brute Force Attack. In a BFA, the attacker downloads the file that...

Brian,

I'm very involved with this type of thing. My main job is running a database for IDS.

By the way, best practice for passwords would be to make you password:

#1ManchesterUnited.

It's harder...

If you are trying to backup to a network share via a JOB, the SQLSERVERAGENT service account needs to have access to the share.

-SQLBill

In your case I would say someone is trying to hack into your server. They are using a tool to run through logins and passwords quickly, most likely a Brute...

Thank you Jonathan. My understanding was that a column wouldn't accept a NULL if a default was set.

-SQLBill

How are you doing your backups?

Are you using SQL Server commands (BACKUP DATABASE) or are you using third-party software (for exampe: Veritas Backup Exec)?

-SQLBill

I don't believe you can use NULL with DATETIME or SMALLDATETIME datatypes. DATETIME and SMALLDATETIME have defaults so that means NULL isn't accepted/allowed (why have a default if you allow...

Is Norton checking the .mdf and .ldf files? If so that is a BAD thing. We had nothing but problems until we found that you should not run Anti-Virus against...

Did you have indexes on the database? They may not have copied over. Also, they may have been reindexed as part of the copy. Did all of your jobs, scripts,...

Why should users change their passwords? For security. I don't know about Charlotte, but I want my users to change their passwords every 6 months. A password that never changes...