the data pages to the beginning of the file. This is an option on the shrink
database screen. Note the warning about performance being affected if you do
this. This is because the file becomes fragmented. My advice is to leave the
log file size alone. SQL Server will only grow the file size if it needs
additional space to log transactions. Once the transactions are done with,
and are clear by backup, SQL Server will just reuse the space. Hope this
helps. --Tom
-----Original Message-----
From: Cenk Ince [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 01, 2004 9:03 AM
To: [EMAIL PROTECTED]
Subject: 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 Links
| 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.
