Not in production; we are still exploring different methods of getting our 7.1/7.0.03 system migrated to 7.5/7.6. I did not have any problems restoring or attaching the ARSystem db from SQL Server 2005 to 2008, but in the one test where I tried to return it to 2005 by exporting it, it tripled in size and refused to shrink. My caution would be that while you can get from 2005 to 2008 without much trouble, don't expect to be able to go back to 2005.
Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Louise Van Hine Sent: Monday, May 03, 2010 10:04 AM To: [email protected] 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]<mailto:[email protected]> 360-201-7580 _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

