1. Not really - you can install 6.3 on 2000 but not 2005, however it still ran for me after I upgraded to 2005.
2. The last time I did this on my 7.x servers (moving the db to a separate server) I simply backed up the full database with all of the apps, installed AR Server over itself (same version) on the AR Server but specified a brand new db on the external SQL Server, then restored the full db to the new location in overwrite mode, changing the mdf and ldf file paths to the new locations as necessary while setting up the restore. It's a little trickier for me since we use Windows-ONLY authentication for SQL server and you have to get the appropriate Active Directory domain accounts set up on the new db server first. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of James Collins Sent: Wednesday, April 11, 2007 2:18 PM To: arslist@ARSLIST.ORG Subject: ARS -SQL Servers Consolidation My group is in the process of consolidating SQL servers. Currently we run ARS and SQL on separate servers. The plan is to consolidate this onto one. I have the following questions, perhaps someone out there in ARSLIST land has some experience and can answer these: 1.) Is Remedy ARS 6.3 and CM 6.0 compatible with SQL Server 2005 ? 2.) How would I make the following modification? My current server has the Remedy ARS and CM application and the SQL database on it - management would like me to move the database to a different server. How do I modify my currently installed ARS and CM so it knows to point to a different server for the SQL database and move the current database over? Thank you and regards, Jim Collins ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"