winng Posted July 13, 2015 Posted July 13, 2015 Hi I've just run through the upgrade routine to use SQL2012 and it went through without any issues. However, it leaves the databases in the SQL2008R2 directories and I am therefore unsure if I have actually upgraded to SQL2012. Is this all I needed to do or should I have installed a new installation of SQL2012 and then used dbAttach to relocate the sims, discover and solus databases?
Banjo Posted July 13, 2015 Posted July 13, 2015 (edited) That's normal. Create a new folder in the data directory (SQL2008) and cut and paste the DB's into that new folder. If they move, then they are no longer attached to the instance. Update your connect.ini to point to 2014 and all done - (unless you used redirect) which I wouldn’t recommend. Edited July 13, 2015 by Banjo
winng Posted July 13, 2015 Author Posted July 13, 2015 (edited) That's normal. Create a new folder in the data directory (SQL2008) and cut and paste the DB's into that new folder. If they move, then they are no longer attached to the instance. Update your connect.ini to point to 2014 and all done - (unless you used redirect) which I wouldn’t recommend. I can't move them as they are in use.... Edited July 13, 2015 by winng
Atomic_Zombie Posted July 13, 2015 Posted July 13, 2015 Log into the 2008 instance with SQL Management Studio and make sure the DBs are detached. If you really want to be sure, stop the SQL2008 service and move the MDF and LDF as @Banjo said.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now