Environment
Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1
Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1 Database
Microsoft SQL 2005
Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1 Database
Microsoft SQL 2005
Situation
MS SQL 2005 database has become very large, and continues to grow rapidly.
Resolution
- Logon to the SQL 2005 server as an administrator
- Launch 'SQL Server Management Studio' from the start menu
- Expand the section 'databases' and locate the relevant database
- Right-click on the database and choose 'properties'
- Select the page 'Options'
- Click 'OK'
- Right-click on the database and choose 'Tasks' - 'Shrink' - 'Database'
- Click 'OK'
Additional Information
Problem is that
the transaction log grows significantly and is only truncated/cleared when doing
backups. If your last backup was some time ago, the issue may be that the log
is too large. Transaction logs are *.ldf files, search for
those files and check to see how large they are. Scheduling regular backups will help prevent this problem.
The ZCM documentation provides good information and links to MS SQL 2005 database maintenance.