Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB

[Varden Morris]

Yes. It's usually the log file. An easier way to accomplish this is to enter the following commands in Query Analyser.
 
Backup log DatabaseName with truncate_onlyDBCC ShrinkFile(LogFileName, 0)
 
It is best to do this after you have done a full backup since you do not want to kill the tranasaction logs that you may need in an emergency to restore the database.
 

Varden Morris
 
J. Wray & Nephew Ltd. - Group I.S.
234 Spanish Town Road
Kingston 11, Jamaica, W.I.
 
Phone:  (876) - 923 - 6141 Ext. 2226Fax:      (876) - 923 - 5372 
Cell:      (876) - 3833566Email:   [EMAIL PROTECTED]
            [EMAIL PROTECTED]               
 Raul Llorente Peña/OPENSOLUTIONS <[EMAIL PROTECTED]> wrote:
Securely the most of increasing have been on Log file. Backup the BBDD, detach it, delete log file, and then reatach the data file. SQL will create a new, empty, very much smaller log file. SQL have provided some shrink options, but they are often few effective. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS Sharing the knowledge on Axapta. __________________________________________________Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection around http://mail.yahoo.com 


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.