-2

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 2

7

Back the whole system and the databases up and follow the upgrade instructions and you'll be fine.

6
  • Silly question. How to back-up whole system? Jun 5, 2013 at 8:46
  • 2
    Yes, 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
  • 2
    Oh 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.
    – Chopper3
    Jun 5, 2013 at 9:42
  • @user960567 Windows 7 is NOT a supported OS for SQL Server
    – voretaq7
    Jun 6, 2013 at 17:13
2

Yes, of-course it is safe. There are two possible ways :

  1. 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

  2. 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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .