Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.clients:30825
Hi,
In SQL Server Enterprise Manager > Space Allocation. I can not reduce the
current size. I can restrict the to current size but I can not reduce it.
This lay person very much appreciates your help.
regards
S
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.805 / Virus Database: 547 - Release Date: 03-Dec-04
Have alook at these:
http://www.nigelrivett.net/Transacti...leGrows_1.html Log File issues
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Tran Log
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
considerations
Andrew J. Kelly SQL MVP
"Neither rhyme nor reason" <sportman_6663@.yahoo.ca> wrote in message
news:4Fl0e.8116$JK1.566630@.news20.bellglobal.com.. .
> Hi,
> In SQL Server Enterprise Manager > Space Allocation. I can not reduce the
> current size. I can restrict the to current size but I can not reduce it.
> This lay person very much appreciates your help.
>
> regards
> S
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.805 / Virus Database: 547 - Release Date: 03-Dec-04
>
Sunday, February 19, 2012
help with large log files
Labels:
allocation,
clients30825hi,
database,
enterprise,
files,
gbl,
log,
manager,
microsoft,
mysql,
oracle,
phx,
public,
reduce,
server,
space,
sql,
sqlserver,
tk2msftngp08,
xref
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment