00197191-02_IM_SIPLACE_Pro_10.1_EN.pdf - 第76页

Installation Manual 8 Uninstalling SIPLACE Pro 10.1 Edition 09/2012 74

8 Uninstalling Installation Manual

Edition 09/2012 SIPLACE Pro 10.1

8.2 Uninstalling the database

8.2.1 On installations of SQL Server

Warning

All data for SIPLACE Pro will be deleted. This step is only for database administrators. 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

Note

This applies to SQL 2005 Express without SQL Server Management too. 8

Installation Manual 8 Uninstalling

SIPLACE Pro 10.1 Edition 09/2012

9 Appendix Installation Manual

Edition 09/2012 SIPLACE Pro 10.1

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

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 settings / a complete da-

tabase backup and archive solution, you may setup an appropriate solution by yourself. 9