Shared memory is a local protocol and can be used only in the machhine where the sql server is running. you can't connect to server using this protocol from a...

Correct me if i am wrong. The concept of virtualization is there in Windows 2008 with SQL 2008. The one that you have now is virtual server concept. There is...

Why do you use XP as your windows server. Xp lacks many features as a server side OS. My recommendation is use windows 2003 server to have many features and...

Go for sql enterprise edition to have all advantages of sql 2005.

Better opt out for a job and schedule to run every 15 mins

read out the windows and sql error logs when the error occurs and post us which would help us to give valid suggestion on this.

do a checkpoint then try to backup and restore hjope this solves.

Change the log shipping configuration to run under the account of sql agent. then check the log shi[pping jobs also to run under the configuration of the sql agent account.

The best option that i would say is go for snapshot replication in non-production night hours to you rtest machine. configure to replicate data and objects.

Check if you have proper registry permissions set up in the machines where you get an error. this is sure to be a permission problem.

It will rebuild the index and not reorganize.

Is remote connection enabled in sql 2005 server?

are you trying to attach with the same name or different?

is the database huge. if so then it will take time to recover. even if you are ging to restart your sql services they wil be in recovery mode and...

Remember that you can't just move the as any user DB. it has lot of constraints. you need to have the edition, verion and the build number smae to restore...