Unanswered: Restoring MSDE backups to SQL Server 2005 Express
We are planning to upgrade our web server, and also upgrade the MSDE database on that web server to SQL Server Express 2005. So, I installed SSE 2005 on my test PC. Then, I performed a full backup of the MSDE databases: master, model, msdb, and my database that contains the data.
I would like to just "restore" these databases into SSE 2005 on the test PC, so that user accounts, etc, also get ported over. Will this work? Or do I have to import only my user-created database backup, and then manually set up the user accounts etc. on SSE 2005? In other words, assume that a server with MSDE crashed, and you want to reinstall everything but upgrade first to SSE 2005 and then do a full database restore. Is this possible?
Retired Moderator at Xtreme VB Talk, for all of your Visual Basic needs.