Solved

using old sql 2008 as backup to sql 2012?

Posted on 2013-12-25
5
278 Views
Last Modified: 2013-12-27
I upgraded our sql to 2012 server in a windows 2012 server box.

The old box is a windows 2003 server box with an sql 2008 installation.  Is it possible to use the 2008 sql as a backup to the 2012 box or do I need to upgrade that also?
0
Comment
Question by:al4629740
  • 2
  • 2
5 Comments
 
LVL 16

Assisted Solution

by:Surendra Nath
Surendra Nath earned 167 total points
ID: 39739291
What do you meant by backup...

do you want to use the SQL 2008, just incase the SQL 2012 box gets corrupted.....
if that is case, then you might run into trouble.

As, SQL Server 2012 has some advanced functionality's which SQL Server 2008, for example the LAG and LEAD functions which are not there in 2008 but in 2012.

Even before going there, you may not be able to restore the backups of SQL 2012 backups on SQL 2008, you may find some info regarding the same here http://www.mytechmantra.com/LearnSQLServer/Unable_to_Restore_Database_From_Backup.html

So, please migrate the other version as well, as there is no backward compatibility.
0
 
LVL 19

Assisted Solution

by:Patricksr1972
Patricksr1972 earned 166 total points
ID: 39739294
Downgrading a SQL Server 2012 database to SQL Server 2008 Is possible but tricky.
IT requires scripting the entire database to an older version.
If you are able to upgrade the 2008 box als well it would be easier to maintain.
0
 
LVL 16

Expert Comment

by:Surendra Nath
ID: 39739296
@Patrick

Downgrading is not always possible...
What if the user uses the new functioanlities provided by SQL Server

For example : LAG Function , LEAD Function in a stored procedure in the future, in SQL 2012 box it will work without an issue at all, but the SP wont compile sucessfully on SQL 2008.
0
 
LVL 19

Expert Comment

by:Patricksr1972
ID: 39739308
Hi Neo,

I agree it is not always possible but for my understanding 2012 has scripts to downgrade db's to sql2008 where newer features are not included.
0
 
LVL 68

Accepted Solution

by:
Qlemo earned 167 total points
ID: 39739453
Having to use scripts to replicate has a lot of downsides, so I would not consider that to be a solution. You'll always have to script the complete database, consuming a lot of resources while doing that.

If you use the same MSSQL release, log shipping and similar replication is possible. Usually all changes are just re-applied to the backup database that way in background. In a more simple way, you just apply the recent backup to the backup database - this doesn't work with backups of a higher release into an older one.

If you are not exceeding the limits imposed by the SQL Express Edition, this could be a cheap alternative to having to buy another 2012 one, "just" for DR purpose.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now