Rather than using the typical way to backup and restore your database, you will need to generate script to backup MSSQL and restore to an older version of MSSQL.
1. Correct to your correct MSSQL database engine using SQL Management Studio.
2. Right click onto your database, select TASKS > GENERATE SCRIPTS.
3. Click NEXT > NEXT > choose "Save as notebook" and click onto the ADVANCED button.
4. Modify the following settings and click OK to proceed.
- Script for Server Version : choose your preferred version.
- Types of data to script : Schema and data
- Script Triggers : True
5. Select where to store your script at "Save as notebook" under 'File Name'.
6. Click NEXT > NEXT > FINISH.
- 0 Users Found This Useful