Database backup restore on lower version in SQL Server


How to restore a higher version SQL Server database backup file onto a lower version SQL Server?
Script generation - Tasks -> Generate Scripts. Make sure you set the desired target SQL Server version on the Set Scripting Options -> Advanced page. You can also choose whether to copy schema, data, or both.



select "Schema and Data" - if you want to Take both the things into the Backup script file
select Schema Only - if the only schema is needed.






Note that in the generated script, you may need to change the DATA folder for the mdf/ldf files if moving from non-express to express or vice versa.

Database backup restore on lower version in SQL Server Database backup restore on lower version in SQL Server Reviewed by NEERAJ SRIVASTAVA on 2:21:00 PM Rating: 5

No comments:

Powered by Blogger.