the size of log try this t-sql comand from the query analyzer screen:
BACKUP LOG 'DBNAME' WITH NO_LOG
Regards.
--- In [EMAIL PROTECTED], "Niraj Patpatia"
<[EMAIL PROTECTED]> wrote:
> If you do a backup of the db and then run ashrink job, it should
reduce
> the size of the file.
>
>
>
> ________________________________
>
> From: Myrl Stadnick [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 30, 2004 4:25 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [development-axapta] (urgent) how to delete log file
from
> SQL server 2000
>
>
>
> Don't ever delete the log file!!! :-(
>
> Myrl
>
>
>
> -----Original Message-----
> From: Cenk Ince [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 30, 2004 2:23 PM
> To: [EMAIL PROTECTED]
> Subject: [development-axapta] (urgent) how to delete log file from
SQL
> server 2000
>
>
> Hi all;
>
> I want to delete log file from my database but i don't know how to
do
> that.
> It's size is very large so i just want to delete it.
>
> Thanks in advance.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
<http://us.ard.yahoo.com/SIG=129os77pt/M=298184.5022502.6152625.300117
6/
> D=gr
>
oups/S=1705006764:HM/EXP=1088712252/A=2164339/R=0/SIG=11e2d64in/*http:
//
> www.
> netflix.com/Default?mqso=60183348> click here
>
> <http://us.adserver.yahoo.com/l?
M=298184.5022502.6152625.3001176/D=group
> s/S=
> :HM/A=2164339/rand=850113663>
>
>
> _____
>
> 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]
subject=Unsubscri
> be>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service
> <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
> click here
>
<http://us.ard.yahoo.com/SIG=129mhrf49/M=295196.4901138.6071305.300117
6/
>
D=groups/S=1705006764:HM/EXP=1088714463/A=2128215/R=0/SIG=10se96mf6/*h
tt
> p:/companion.yahoo.com>
>
>
> <http://us.adserver.yahoo.com/l?
M=295196.4901138.6071305.3001176/D=group
> s/S=:HM/A=2128215/rand=776010771>
>
>
>
> ________________________________
>
> 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]
subject=Unsubscri
> be>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
> [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.
