SQL SERVER – Restoring 2012 Database to 2008 or 2005 Version and 2 other Most Asked Questions

SQL SERVER - Restoring 2012 Database to 2008 or 2005 Version and 2 other Most Asked Questions web Some questions never get old. Let me list a few of them. As the year 2012 is about to end, today I will talk about three of the most asked questions to me in an email. Let us learn about Restoring databases.

Q 1: What is AdventureWorks and where can I get it?
A 1: AdventureWorks is sample database build by Microsoft for running sample/demonstration queries for the user. You can get that from here. I have written an article on this subject earlier and have created video as well.

Q 2: Can I restore database backup taken from 64-bit server to 32-bit server and vice-versa?
A 2: Absolutely, You can do it as backups are just a file. Just like any other files (JPG, docs, etc) you can use them in 32 bit and 64 bit application server without any issue. The issue related to the platform should only arise with the application (like SQL Server, Office etc.).

Q 3: Can I restore a SQL Server 2012 database to earlier versions like 2008 or 2005? Or How to Downgrade my Database to earlier versions?
A 3: No, you can only move forward. This means, you can restore the database from 2005 or 2008 to 2012 version but can not do it in reverse order. The next most popular question I receive is if we can’t restore a SQL Server 2012 database to earlier version what is the next best option? I have personally faced this issue once before and I had manually created T-SQL script using Script and Data Generator Wizard in SQL Server 2012  (Watch Video over here) and rebuild my database in SQL Server 2008R2. If you have many different databases which you want to address, you can use SSIS to automate the script generation.

Here is one question, I always ask back to my users – why do you want to downgrade your database? I have hardly gotten a valid detailed answer on this subject. Did you face similar situation ever in your future? If yes, I would like to know more about it.

And one more thing…

SQL SERVER - Restoring 2012 Database to 2008 or 2005 Version and 2 other Most Asked Questions happyholidays

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Backup, SQL Restore, SQL Server
Previous Post
SQL SERVER – Fix – Error: 4214: BACKUP LOG cannot be performed because there is no current database backup.
Next Post
SQL SERVER – Creating Database with Different Collation on Server

Related Posts

54 Comments. Leave new

  • hola, necesito saber como puedo restaurar una base de datos de SQL 2012 en un SQL 2008 R2, por favor le agradecería si pudiera ayudarme.

    • No hay manera de hacerlo.

    • Si se puede, pero a través de scripts como dice el artículo. Yo lo llevé a cabo el día de hoy, me traje una base de datos en SQL Server 2016 64bits a una estación de trabajo con SQL Server 2008 R2 en Windows 7 32bits. Debes ir a “Tasks >> Generate scripts” y en las opciones avanzadas escoges la versión de SQL y le das en “Script Schema and Data”.

  • Radu Costescu
    June 15, 2017 3:36 pm

    Hello Dave,
    Sometimes (extreme case, indeed) there is the need to migrate the DB from 2012 to a lower version. My case, we have two distinct servers, with two distinct databases, for two distinct functionalities. Now we have a development project which will require to take over functionalities from 2012 database into 2008R2 database. The problem is that, being a production server with multiple connections to other locations, upgrading the 2008R2 to 2012 is a very tricky task and the customer refuse to do it, so I have no other option than trying to move 2012 DB into 2008R2. Any hint will be greatly appreciated. Thanks

  • what happens when database is huge? can this method work?


Leave a Reply