MS SQL Standard to Express Migration

Can anyone tell me the steps of moving from SQL Standard 2000 to Express 2005/ 2008 on the same machine?
Who is Participating?
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Steps below:

* Take a backup of all user databases and system databases
* Transfer logins script as per
* Uninstall SQL Server 2000
* Intall SQL Server 2005 / 2008 Express
* Restore User database and system databases backups
* Run logins script created earlier.
tru504187211Author Commented:
Is it possible to stop SQL Server before installing SQL Express?  (just to make sure a rollback could happen if something goes wrong)
Raja Jegan RSQL Server DBA & ArchitectCommented:
If you prefer that way, then your SQL Express instance installation should be done as a named instance.
Difference being Default instance would be referred as Servername and named instance would be servername\instancename.
Then you need to change the servername in all the applications that uses your database.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.