There is just not enough information to give a helpful answer. I'll try.

Q1. Import what, and to where? If you are asking if the job text itself, written...

No problem. I know it does sound strange, but auto grow is great - only as a last resort. Auto shrink is terrible and should be removed from SQL Server...

TO DISK = '\\MyComputerName\C$\MyBackUps\TestBackup.BAK'

-or-

TO DISK = '\\MyComputerName\MyBackUpsShared\TestBackup.BAK'

Use RAID 10 instead of 5. Faster writes (about 30% or so?). Requires at least one more disk.

Use RAID 10 instead of 0+1. Same disk numbers, but better fault tolerance...

The use of AWE indicates that this is may be an x32 system with AWE enabled. When AWE is enabled, RAM is reported inaccurately in task manager or similar, however,...

Yep. Target cache hit ratio should be about 99% in most cases.

Your high cache hit shows that the ram allocated to SQL server is working great, however the high...

Paul,

You rock. Thanks for the treaure chest of info!

Jim

Paul,

No sweat man. You post kind of a lot so it is easy to have all of the threads blend together.

I'm sure you will address the CXPacket always being...

It sounds like you are using SSMS to create the backup. If you do not want to append the backup to the previous file in a set, just switch...

Peter - there is much more too it than file system permissions. Please refer to the links in my previous post for more information.

Jim

Paul,

Please do tell me where I misspoke. I would hate to have misinformation up to confuse people for years to come. I'd like to edit and correct anything...

Hey Peter,

There is more info about setting up a lower priv account to run SQL server here: http://msdn.microsoft.com/en-us/library/ms143504.aspx.

See this for the security risk: http://www.sqlservercentral.com/blogs/brian_kelley/archive/2009/11/13/why-we-recommend-against-xp-cmdshell.aspx

Jim

Oh good. Glad you are back up and going.

It is not possible. Under normal circumstances. Is a process/job backing up and restoring to the other instance each night? ...

Ah, OK. Glad it's resolved.

Sounds like it was a permissions issue with that account not having permissions to the data files.

Local system is a very high priv account...

Uh, ya. That's not normal behavior. You should bet the error you describe when attempting to attach in-use files. Almost sounds like the migration restored over top of the other...