Both sql 2008 and sql 2012 co-existing after upgrade from SQL 2008 to 2012.
-
hey guys,
we upgraded our SQL Server from 2008 to 2012, the db was successfully but the funny part is both SQL 2008 and SQL 2012 co-Exist.
if you make any changes to 2008 database using sql server management studio those changes will be reflected to 2012 and vice versa.
here the database is not duplicated but both the 2008 and 2012 is pointing to the same DB.
any ideas guys? my requirement is that only SQL 2012 should be there. Any trace of 2008 should be removed.
please help.
-
Are you sure it's not just both sets of Management Studio tools?
What do you get when you run PRINT @@VERSION?
-
The whole tool sets for 2008 and 2012 are existing not just the management studios
and while running the @@version on both 2008 and 2012 will give the result,
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
-
When you are doing an inplace upgrade,the earlier version(in your case 2008 ) tools exist on the server. You have to remove it manually from the server after upgarde.
-
ashish.george (8/18/2014)
The whole tool sets for 2008 and 2012 are existing not just the management studiosand while running the @@version on both 2008 and 2012 will give the result,
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
In that case just uninstall the 2008 Management Studio stuff. You're definitely running on 2012 SP1 alone.
-
removing the 2008 from the applications will not affect the 2012 right, its a live server.
how about removing the 2008 completely from the add or remove programs?
-
Well, always take a backup first to be sure, but yes.
If you're not comfortable doing it in work hours, maybe just delete your desktop shortcut to it (2008) if you have one, and only use the 2012 Management Studio.
Also, be sure to use the 2012 Configuration Manager. The 2008 one doesn't work with 2012, I don't think (it's been a while since I've tried so I'm not totally sure but I think that's right).
-
the only problem is that what all changes made to 2008 is reflected on the 2012 DB,
u try creating a new Test Db on 2008 and u open 2012 management studio u can see it there. W.E.I.R.D
so uninstalling 2008 might effect 2012? in any way?
-
No. You only have 2012 installed. You've proved that by checking the version. The 2008 stuff you are seeing is purely just the front-end tools. Your instance is ONLY on 2012 (based on the information you've supplied).
It's like being able to open a Word 2013 document with Word 2007 AND Word 2013. You can use either, but if you use the older technology you won't get all the functionality.
As I said, always back up everything before you start, just in case, but if you're unsure what you're doing, don't touch anything.
-
thanks bro, i will take a full backup and uinstall sql 2008.
will share the results, as soon as its done.
-
ashish.george (8/18/2014)
the only problem is that what all changes made to 2008 is reflected on the 2012 DB,u try creating a new Test Db on 2008 and u open 2012 management studio u can see it there. W.E.I.R.D
Perhaps a diagram can assist your understanding.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply