I have read and heard from a few people that 1.5 times is recomended but I have also read up to 3 times if Analysis Services is installed too.

http://technet2.microsoft.com/windowsserver/en/library/68d267c8-9f3f-44e0-923f-0bda8129f9b01033.mspx?mfr=true

Can't backup master tran log even though it will allow you to change the recovery model.

Dave, The page file is way undersized. Microsoft recommends a page file of at least 1.5 times the size of the physical memory. Your page file should be around 21GB not...

Check this blog. It may help you.

http://blogs.msdn.com/nikop/archive/2005/03/04/384972.aspx

If your databases are out of sync you can check the SQL Server log of the monitor server to find out how far out of snyc they are.

What about using a mapped drive letter to the UNC path? Have you tried that for SQL 7?

Support for SQL 2000 is ending soon. Any reason why your are not moving to 2005?

http://support.microsoft.com/lifecycle/?p1=2852

If the db's are a backend for a purchased application, it's nice to split the files to make FTPing easier for troubleshooting but that is usually an ad hoc backup.

Sign up for the CTP and you can check out 2008 for yourself.

https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395

Sorry. Forgot the 2nd part of the question. 64K stripe.

If you have the disk space.

Have a RAID 10 LUN for each logical processor in the machine to spread the data files....

Number 4 is the best option you have listed.

You may be disappointed if you believe SQL 2008 will be available in Feb. 2008.

Microsoft says the product will be "Released" in Feb. 2008 but "Available" and "Released" are 2...

1. Attach the new SAN drive to the server.
2. Stop SQL server.
3. Copy the data and log file to the new SAN drive.
4. Rename the SAN drive letter to match where the db was...

This may be a designed behavior by SQL Server in order to identify which user created the DTS package. I have confirmed this happens in SP4 also.

There is no way to tell which index is in which data file if the tables and indexes are in the same filegroup. However, if the indexes are in a...