Greetings,

The best solution is to use the copy database wizard (right click on the database, task, copy database).

Do that for each database, so you'll have moved the data, jobs,...

Greetings,

It depends how your instance is setup and the operating system.

I suggest you give more details or read up on AWE. 🙂

Best way to check is right-click on the instance...

Greetings,

This is normal behaviour when a rollback operation is going on. Even if you shut down and restart SQL Server service, it will pick up where it was left (and...