databasenya waktu di buat pake log file apa gak?


biasanya yg bengkak itu log file, lakukan maintenance rutin untuk ngosongin log file

BACKUP DATABASE DIRECTORY 'D:\\backup' TRANSACTION LOG TRUNCATE

ntar log filenya dikosongin, backupnya ke copy ke folder d:\backup


sekali2 servicenya di stop, trus file dbnya di defrag, ini utk perawatan.


cek juga dbspace2 nya, jgn terpaku cuma pada satu dbspase (default system), biar gak berat bikin dbspace di file yg berbeda di harddisk yg berbeda misalnya.


oke bun? 
pak iwan msh di batam?



>

Dear All

 

Ada yang tau gimana shrink database ASA

 

Thanks

 

 





-- 

Best regards,

 sandy                            mailto:[EMAIL PROTECTED]

__._,_.___

-----------------------------------------------
IndoPB - Indonesia PB User Group
An Indonesian PowerBuilder User Group's Event
2nd PowerBuilder Update
Rumah Sakit Jantung Harapan Kita
26/27 August 2006
To Register :
http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4




Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___

Kirim email ke