Relocation of database

Description of the problem

This article describes the relocation of the steadyPRINT database to another database server.



Solution

Creation of the database backup
First of all, the existing steadyPRINT database has to be saved. A backup can be done via the Microsoft SQL Server Management Studio under [INSTANCENAME] > Databases > [STEADYPRINT DATABASE] > Tasks > Back Up ….

Import backup to new database server
Now, the backup of the database has to be imported to the new database server. This procedure can for example be done via the Microsoft SQL Server Management Studio under [INSTANCENAME] > Databases > Restore Database. It is recommended to use a suffix describing the respective steadyPRINT Version:
Example: PrinterMap_510

Restore database permissions
After restoring a database, the permissions for the SQL user might get lost. In order to adjust this process, please follow the knowledgebase entry No access to the database after restoring on https://www.steadyprint.com.

Link of the steadyPRINT components to the new database server
Reinstall the steadyPRINT components by indicating the new database login information.

Related links
http://steadyprint.com/user-manual/manual.htm
https://www.steadyprint.com/no-access-to-the-database-after-a-restore/

ID: sP00000 | Created on: 30-March-2015

Back to overview