routines are set properly running the following commands in Query
analyzer will force the shrink of the database and log file. Replace
dbName with the Name of the database, Percntage in the second line is
the percent of available free space to have after the shrink, set this
at a value that will allow for growth, 33% is a good number. These will
truncate your transaction log and shrink the log and DB files be sure to
have a full backup before doing this.
-Preston
Backup Log dbName with truncate_only
DBCC ShrinkDataBase (dbName, Percentage )
-----Original Message-----
From: Matthias Schuster [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 2:43 PM
To: [EMAIL PROTECTED]
Subject: AW: [development-axapta] (urgent) how to delete log file from
SQL server 2000
Hi,
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:/c
ompa
nion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/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]
be>
* 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
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129ha13cg/M=295196.4901138.6071305.3001176/
D=groups/S=1705006764:HM/EXP=1088798216/A=2128215/R=0/SIG=10se96mf6/*htt
p:/companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=200216699>
_____
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]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> 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.
