How to backup and then store MSSQL database to older version

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 brukere syntes dette svaret var til hjelp
Var dette svaret til hjelp?

Relaterte artikler

SolidCP & MSPControl: Create MS SQL database

Please follow the steps below to create your MSSQL Server Database in control panel. * Please...

SolidCP & MSPControl: How to backup MSSQL database via control panel

You can backup the entire MSSQL database from hosting control panel.Please follow the steps below...

How to connect to MSSQL database using SQL Server Management Studio?

To manage your MS SQL database using SQL Server Management Studio.SQL Server Management Studio...

How to connect to older version MS SQL using Enterprise Manager?

To connect to older version of MS SQL database (such as MS SQL 2000), you can use Enterprise...

Connection strings for SQL Server

Connection string is a string that contains information about a data source and means of...