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...

the white icons mean you do not have permissions on that server to manage the sql services (stop,start, etc)

dont forget to carry out the post 2005 migration tasks.

run dbcc update usage and rebuild all indexes\stats

attach the databases first as when the script is applied to add the logins it will fail as the users default database does not exist. Maybe it doesn't really matter...

tee hee hee ROTFL

undoubtedley the best way to go

awp (12/11/2008)

---

my plans are as follows:

- script all the logins from sql 2000 instance and...