there are many different ways for shrinking the log-Files. The clean one is
right-click on database, all tasks, shrink database.
This only works if you saved the transaction log before. If there are
several log files you can do it for each file.
The faster - and maybe a little less cleaner way - is described here:
I tried and it worked, but be carefull :-) . I think it should be your final
option!
http://www.databasejournal.com/features/mssql/article.php/1460151
cu
M
_____
Von: Cenk Ince [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 1. Juli 2004 18:03
An: [EMAIL PROTECTED]
Betreff: RE: [development-axapta] (urgent) how to delete log file from SQL
server 2000
First i want to thank for all replies;
But i couldn't solve problem, when i shrink db, the physical file size
is not getting smaller. How can i get it smaller?
Thanks in advance.
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129scgsv3/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705006764:HM/EXP=1088793832/A=2128215/R=0/SIG=10se96mf6/*http:/compa
nion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=294224574>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
