How to Do when Database is so large?
c:\AAMailPro\dbs\sqlldapinfo.mdf
This database file is for "sqlldapinfo" database. It keeps all information of accounts and system logs. If it is very large, you can do followings to shrink it.
- Open SQL Server Enterprise Manager.
- Choose "sqlldapinfo" database as target and start a new query.
- Run "truncate table systemlog" statement, this will empty systemlog table.
- Select "Shrink database" task, select sqlldapinfo database and using Precise Shrink mode.
- Shrink it.
c:\AAMailPro\dbs\sqlmaildata.mdf
This database file is for "sqlmaildata" database. It keeps all information for deocoded mails, attachments and pop3 UIDs. If it is very large, you can do followings to shrink it.
- Open SQL Server Enterprise Manager.
- Choose "sqlmaildata" database as target.
- Select "Shrink database" task, select aamailpro database and using Precise Shrink mode.
- Shrink it.
c:\AAMailPro\dbs\sqlldapinfo.ldf
c:\AAMailPro\dbs\sqllmaildata.ldf
The above two files are log files for "sqlldapinfo" and "sqlmaildata" databases. They are managed by SQL Server. If the two files are very large, you can do followings to rebuild them. Let's take "c:\AAMailPro\dbs\sqlldapinfo.ldf" as an example.
- Open SQL Server Enterprise Manager.
- Detach "sqlldapinfo" database.
- Rename sqlldapinfo.ldf to sqlldapinfobackup.ldf in Windows Explorer.
- Attach c:\AAMailPro\dbs\sqlldapinfo.mdf.
- Note to remove the auto-added log file when attaching, we need SQL Server to create an empty log file.
- If sqlldapinfo is attached OK, delete sqlldapinfobackup.ldf.
|
 |
|
Youngzsoft
Products
About Us
