June 26, 2011 at 4:13 pm
Hey guys, I tried upgrading my SQL Server 2005 to SS2008 and kept running into issues. Namely, the database engine handle failed error. So I ended up just uninstalling everything and doing a clean install of SQL Server 2008, instead of an upgrade. Well I am restoring my database to SS2008 by using my database backups, but I am unsure how I am supposed to restore master and msdb since they are from a SS2005 server. I get an error saying they are different. I'd like to restore them so I get all my SQL Agents and scheduling back. Otherwise, I don't really think I need to restore them unless someone can tell me otherwise on these forums. Thanks.
June 26, 2011 at 6:45 pm
coder_t2 (6/26/2011)
Hey guys, I tried upgrading my SQL Server 2005 to SS2008 and kept running into issues. Namely, the database engine handle failed error. So I ended up just uninstalling everything and doing a clean install of SQL Server 2008, instead of an upgrade. Well I am restoring my database to SS2008 by using my database backups, but I am unsure how I am supposed to restore master and msdb since they are from a SS2005 server. I get an error saying they are different. I'd like to restore them so I get all my SQL Agents and scheduling back. Otherwise, I don't really think I need to restore them unless someone can tell me otherwise on these forums. Thanks.
You cannot restore master and msdb from an earlier version. You need to script out the objects you want to transfer over. For logins, search for sp_help_revlogin and use that - for agent jobs you can select them all, right-click and script objects.
If you have other objects, you can post back here for suggestions on how to transfer them over to the new instance.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 26, 2011 at 8:17 pm
Ok thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply