From http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

When a principal database is exposed, it is active with user connections and processing transactions. However, no log records are being sent to the mirror database, and if the...

You'll need AWE enabled within SQL, no switches are required for the OS. While Windows can address all the memory, being 64 bit, SQL 2000 being only a 32bit process...

If you had mentioned that this was only an issue through the app and not when run manually, which was what everybody thought, this could have been resolved a long...

Use sp_helprevlogin to move the logins.

Backup the databases and restore on the 2005 servers.

Once a database has been on 2005 you cannot get it back to 2000, so to prevent...

Try setting the instance to a particular port and see if you can login using that port, rather than a dynamic one.

richcoulson (1/9/2009)

---

We have a warehouse database that is normally around 400gigs which compresses down to 80gigs with row level compression. Performance of queries varies widely depending on the disk...

This big much as my son would say

The indication is that the account you are logged in as does not have the permissions to start the service. Try changing your login to an account that has those...

It's invisible to TDE.

No, it's nice that you've done your independent research, and come to a conclusion that you believe in.

It doesn't matter whether or not it would match mine, the due diligence...

You can run an xp_cmdshell with textcopy.exe

Have you tried the restore statement using the WITH MOVE option to change the physical file names?

Did you confirm that the object_name(904519893) exists?

Can you post the create statement for the table and any associated triggers or indexes?

Why would you put 10GB of memory in a server and restrict SQL to 2GB? Unless you have a whole load of other things running on there.