all groups > sql server connect > november 2003 >
You're in the

sql server connect

group:

DBCC SHRINKFILE not working...



DBCC SHRINKFILE not working... aleXsticY
11/28/2003 1:22:28 PM
sql server connect: Hi,
why would DBCC SHRINKFILE not work? It is not reducing my
Transaction Logs on MSSQL 2000.

Thanks,

alex.

Re: DBCC SHRINKFILE not working... John Bell
11/28/2003 8:57:35 PM
Hi

Check out :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_1uzr.asp

and the following KB articles:

INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/default.aspx?scid=kb;en-us;256650

INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/default.aspx?scid=kb;en-us;272318

Log File Grows too big
http://www.support.microsoft.com/?id=317375

Log file filling up
http://www.support.microsoft.com/?id=110139

Considerations for Autogrow and AutoShrink
http://www.support.microsoft.com/?id=315512

http://www.mssqlserver.com/faq/logs-shrinklog.asp

John

[quoted text, click to view]

Re: DBCC SHRINKFILE not working... Hari Prasad
11/29/2003 7:00:13 PM
Hi,

Try removing the active transaction using "Backup Log" command and then
issue the DBCC SHRINKFILE command.

Thanks
Hari
MCDBA



[quoted text, click to view]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_da2_1uzr.asp
[quoted text, click to view]

AddThis Social Bookmark Button