Reduce database size for archiving
I have one database thta have lage size,now i am trying to archive that database,I al ready reduce 40,000 documents from that databse to archive Dbase,but still the database size is same, some please guide me it very urgent
Software/Hardware used:
Software/Hardware used:
ASKED:
March 8, 2009 11:29 AM
UPDATED:
March 9, 2009 2:20 PM
RELATED QUESTIONS
- I am using lotus 7.0.2 and my archive size was suddenly reduced from 4gb to 0kb and File is not a Database error is comming when i am openning the arc
- Lotus archive size automatically reduced
- Move messages from one Lotus Notes archive to another
- How to solve an Outlook archiving problem
- Lotus Notes archive database error message: 'Database Corrupt--Cannot Allocate Space'
Answer Wiki:
If you are using Microsoft SQL Server then you can use the DBCC SHRINKFILE statement to make the database smaller.
However it is recommended that you not shrink the file as this causes fragmentation and decreases performance.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
