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"
    

Reply via email to