update stats using

sp_updatestats

that is the option that should used

if for some reason you dont bring the logins across all is not lost

example.

database A has a user called BOB and there is a login called BOB on SQL server...

thanks m8tey, at least i learnt something at school all those years ago.

exactly my thoughts

when you run the SP it gives you the details of any database instances and comonent tools. Re run it and post a screenshot can you

ps (12/13/2008)

---

You can also create a dummy database with the same name as your original database, shut down sql server service and overwrite your data files with original files. Restart...

ensure you set the min and max memory to the required settings for the RAM you are using

query plans are held in cache memory, are the machines the same spec or different (cpu and memory)

i havent done this...

can you change it back again?

can you post the complete error message?

aside Gails recommendation, why pre create the databases before restoring the backups.

detach, copy and attach would be my preference. Drop the existing databases you...

it would be more important to try and ascertain what is causing the paging

your talking share permissions here right?

What "security" permissions did you set?

no, under sql2005 AWE applies to 32bit Std, Dev and Ent as does the lock pages in memory option.

http://msdn.microsoft.com/en-us/library/ms175581(SQL.90).aspx

Under sql2005 64bit only Ent...