Louise, Change the compatibility mode to 2005.
Check out the help on stored proceedure sp_dbcmptlevel. http://msdn.microsoft.com/en-us/library/ms178653.aspx You will need to create the database on 2008 manually and using the above stored proceedure, bring the compatibility level to 90 which represents MS-SQL 2005. Then restore the 2005 database. Hope this helps.. Cheers.. Joe D'Souza ________________________________ From: Louise Van Hine <[email protected]> To: [email protected] Sent: Mon, May 3, 2010 11:03:50 AM Subject: restoring DB from SQL 2005 to SQL 2008 ** Hi List, Has anyone done a database refresh (restore) from a SQL 2005 instance under the covers to a SQL 2008 DB? BMC is saying that this is not supported, but we have done this into our TEST and DEV systems and now have refreshed our DEV with production which is still on SQL 2005, and are about to perform the ARS upgrade to 7.5 and then ITSM from 7.0.3. to 7.6. Has anyone done this in a production environment? So far everything looks okay, our CMDB relationship viewer is happy, our consoles are happy, we had a bit of a glitch with initially connecting but that was because the configuration had a connection setting wrong initially - that got corrected and regression tests seem to be passing. Many thanks for any and all comments, Louise van Hine Independent Consultant [email protected] 360-201-7580 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

