I don't believe that MSDE is cluster aware. You should see it on the node that you installed it on, but not on the clustered node.

Backup/restore is my method. sp_help_revlogin from MS's site can get logins. For DTS, I'd save off, open on the new server, you can script the jobs.

That's teh best way and then block the ip at the router while you investigate.

According to SQL 2000 BOL (didn't check 7 ), the SKIP option does not check for expired backups, so it would cause issues. The...

I think you may have some other isssue. If you change the status and reset the suspect flag and it still doesn't recover, you probably need to call MS. I'd...

If you are using Windows Auth in IIS, then you add the people to the SQL SErver using their windows accounts. If you don't want AD groups, I'd at least...

Is the year correct?

Is this for development? Or admin? for admin, have them create a db, back it up, then restore it as a different name.

for development, have them write a report you...

Are there multiple files for the data? You can use sp_resetstatus, but you want to resolve the issue that caused it to be suspect. Perhaps a file was locked by...

A torn page usually means an incorrectly linked page in the file. Likely the file itself is corrupt somehow. I'd get Backupexec and MS on the phone ASAP to work...

You need to talk to people that do this sort of thing, like NasDaq, Dell, etc. People that need to handle high volumes with high uptimes on MS technology. It...

Separation. We had to move the email server to a separate location from which we can send the newsletter. Took some tinkering, but we basically have 1 T-1 for the...

Are implicit transactions turned on? Haven't noticed this, but I don't do much XML work. I'll have to take a look.

Test your restore in QA, then take the script adn put it in the -Q parameter as shown by  Amit above.

I've had a number of 4GB machines and they never go above 1.7GB. It seems that the server algorithms that balance memory with the OS max out here.