Reputation: 65
back up DB to an older version
I have two SQL Servers of different versions: 2014 and 2012. I cannot upgrade the oldest to the newest one. Can I back up a DB on 2014 so that I can restore it on 2012? I would like to restore both schema and data. I would also prefer to do it through backing up, not through scripting out. Right now I am getting an error saying something like "the versions are incompatible, and you cannot restore the DB". I appreciate your help.
Upvotes: 0
Views: 211
Answers (1)
Reputation: 1813
You can't back up & restore the database from a higher (2014) to lower (2012) version.
You can generate a script from SQL Server 2014 (DB creation and data creation script) and you can run on SQL server 2012. Only scripting is an option in this scenario to create a database/restore a database from SQL server 2014 to 2012.
You can certainly take a back from SQL server 2012 and restore in the SQL server 2014.
Upvotes: 1
Related Questions
- SQL Server database backup restore on lower version
- restoring backup from different version
- Move SQL Server database from new version to old version
- Backup and Restore SQL Server database from higher version to lower version
- Migrate a SQL Server database to a lower version
- Move database from sql server 2008 to 2005
- Restoring database to an instance with a lower version
- What version of SQL Server do I need to move database to production server?
- Downgrading SQL server 2008 to SQL Server 2005
- Backup SQL Server database