I am using SQL Server 2008 R2 quite a while. It is working great. Now I need to use SQL Server 2012. Will this effect my existing database. How much Risk involved in installing SQL Server 2012 on a machine that have SQL Server 2008 R2 running.
2 Answers
Back the whole system and the databases up and follow the upgrade instructions and you'll be fine.
-
-
2Yes, that is a silly question as you should alreay be doing backups of your systems. Quickest easiest way to take a single backup is using the Windows Backup Componets; you will need to add that feature to your windows install. Jun 5, 2013 at 8:51
-
@MarkHenderson, Is Windows Backup Componets is available in Windows 7? Sorry I am beginner? Jun 5, 2013 at 9:13
-
2Oh for heavens sake, are you doing this on Windows 7? if so then please read our FAQ, this site is for PROFESSIONAL sysadmins, who would never do this.– Chopper3Jun 5, 2013 at 9:42
-
Yes, of-course it is safe. There are two possible ways :
Upgrade your existing instance : In this case I would suggest you download and follow Upgrade Advisor http://msdn.microsoft.com/en-us/library/ms144256.aspx
Installing named instance : Another option is to install a named instance, this way you will have both the instances available - SQL Server 2008 R2 and SQL Server 2012.