Cookie Consent by Free Privacy Policy Generator Update cookies preferences
All Categories Database Management Restoring a Database Backup

Restoring a Database Backup

If you need to move your Tascus database to another server, or you need to restore an older version of the Tascus database, follow the steps in this guide.

To perform the steps in this guide, you will need access to the server on which the Tascus database is stored, and SQL Server Management Studio.

Backing up the existing Tascus Database

Start by opening SQL Server Management Studio, and finding the Tascus database to be exported or backed up.


Then, export the database to the local server's backup folder.


Then, using Windows explorer, find the backup file - and move it over to the destination server. Use 7zip to compress the database to a manageable file size - it will likely compress to about 10% of it's uncompressed size.


Note - some very large databases are split across multiple files. If so, the method described above will not perform a full export of the database (it will export only the first file, leading to an error message when importing). If this is the case, follow the steps in this article, under Database split over multiple files.

Restoring a Database

Once you have moved the exported database over to the destination server, and extracted it again, using 7zip. Place it in the backup folder for the SQL server version you are using.

E.g. C:\Program Files\Microsoft SQL Server\MSSQL14.SQL2017\MSSQL\Backup


Follow the on-screen prompts to select the correct backup file.


Once you have followed these steps, the database should import. If you have any errors at this stage, check if the database is split over multiple files.


Finally, you will need to check that the database users will be able to login to the database on the new server.

Expand Security > Logins and check that users have the correct permissions for the new database.


Was this article helpful?

Thanks for your feedback!