Why do you have to restore them on both nodes? Curious. The restore on the one node should be sufficient correct? Is this for a build up or did the...

I assume you are referring to the crdate from the sysobjects table? Any service packs / patches applied? Changes to database settings?

I am by no means a SAN engineer. What you are stating in that the IO will be spread across all the disks is true however, that should be true...

Just so I can understand better, are you saying that all the tempdb files that you created / added are on the same volume group? If so, then what was...

You will have to look in the publication table for the database and you will probably find the related record still showing there. You should be able to delete that...

Yes, and it is always a fun task unless you have IT savvy management, which I have now. The key thing to remember is that they are focused on the...

You can use EM or T-SQL. For T-SQL you would use

alter database DBName add filegroup FILEGROUPNAME

go

alter database DBName add file (NAME = 'Name', FILENAME = 'D:\MSSQL\NAME_Data.NDF', SIZE = xxxxxKB,...

SQL Server can be licensed in a couple of ways, one of them being "per seat", at least that was the old naming for it. With that model the number...

You could try. It would seem like that would definitely remove some IO from the drives that are to be focused for true data activity so, it may work out...

I would be really surprised if a write on a RAID 5 15K disk group is slower than a 7200 write but, I may be wrong. I know using 7200...

Most times when questions like these come I always have to answer with "it depends" but in this situation, go with option 1. The rpm speed is an issue and...

Trust me, this stuff can be difficult so, don't feel bad. I really would recommend that you read up on both of these items in BOL as they are complicated...

As a test can you run the backup job to see if it picks up the new database without having to "tweak" the maintenance plan? Very curious as what you...

Yeah, you should limit the run time. Example, let it run for a couple of minutes then stop the job until you can get things cleared out. As stated in...

You might want to try updating MDAC on that one client to see if that fixes the issue.