No to be rude, but I don't think anyone addressed my original issues.

I set the server to single user mode.

I then restored from tape with the TSQL code I listed.

Once...

SQL Server 2005 standard edition has no RAM max:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

(Well the max of the OS)

Wouldn't this solution be better than placing your formatting in the SQL statement?

This way reporting services handles it when it displays it, however, if you format that in the SQL...

Are those machines running something else OTHER than SQL Server?

If you have 8 GB of RAM, then why limit it to only 2GB? What is the other 6GB of...

I have a linked server between 2005 and 2000.

HOWEVER, I did hear that you may have issues if your 2005 server is running 64 bits while the 2000 server is...