00197696-02_IM_SIPLACE_Pro_12.1_EN.pdf - 第78页
Installation Manual 8 Uninstalling SIPLACE Pro 12.1 Edition 04/2015 76
8 Uninstalling Installation Manual
Edition 04/2015 SIPLACE Pro 12.1
75
8.2 Uninstalling the database
8.2.1 On installations of SQL Server
8
On SQL Server: Go to Enterprise Manager".
On SQL Server 2005 or newer: Go to SQL Server Management Studio.
Select the database "SIPLACEPro".
With the right-mouse button select "delete".
All database files of SIPLACE Pro will be deleted.
8.2.2 On MSDE installations
Uninstall the MSDE instance used for SIPLACE Pro.
Remove the database files.
8
Caution
All data for SIPLACE Pro will be deleted. This step is only for database administra-
tors.
Note
This applies to SQL 2005 Express without SQL Server Management too.
Installation Manual 8 Uninstalling
SIPLACE Pro 12.1 Edition 04/2015
76
9 Appendix Installation Manual
Edition 04/2015 SIPLACE Pro 12.1
77
9Appendix
9.1 Database Maintenance Tasks
Depending on your SQL Edition, different database maintenance tasks will be defined:
SQL Express Editions: 9
– Execution method: scheduled task executing batch file
– Recovery Mode: Simple
– Backup Method: Fullbackup for weekly and daily task
– Backups will be archived for 2 weeks
SQL Server Editions: 9
– Execution method: SQL Agent task
– Recovery Mode: Full
– Backup Method: daily task: Transactionlog Backup; weekly task: Fullbackup
– Backups will be archived for 4 weeks
9
Note
Backups for SQL Express will only be archived 2 weeks because in this case there will
be always made a full backup which requires more disk space. If you require other set-
tings / a complete database backup and archive solution, you may setup an appropriate
solution by yourself.