Re: Assigned Space

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 11:46:12 +0100

Hi

Which file is this? If a database (mdf,ndf or ldf) file check out:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_8b51.asp

If this does not work 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

"David G" <anonymous@discussions.microsoft.com> wrote in message
news:6A6376F5-2D53-4799-B8BA-3737CD4DF4B8@microsoft.com...
> Can anyone help?
>
> I have assigned space to a file in Sql. I need to reduce the space but it
will not let me. I think it is because the space has been assigned. Help

Relevant Pages

  • Re: Changing database size
    ... It seems like you are saying that you can shrink the ... size of a database file using ALTER DATABASE without the usage of DBCC ... transaction log files renders corrupt databases. ... How to Shrink the SQL Server 7.0 Transaction Log ...
    (microsoft.public.sqlserver.server)
  • Re: AutoShrink Database Transaction Log
    ... Shrink implies actually reducing the amount of space used by the actual OS ... There is not a check box setting to autoshrink the log and not the database. ... > I am using SQL Server 2000 Enterprise Edition with SP3A. ... > Is there away that can I autoshrink the database> transaction log and not the database? ...
    (microsoft.public.sqlserver.server)
  • Re: how to reduce log file size?
    ... How to Shrink the SQL Server 7.0 Transaction Log ... Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE ... Log File Grows too big ...
    (microsoft.public.sqlserver.server)
  • Re: Transaction log keeps growing
    ... Introduced in SQL Server 7.0 was the ability automatically grow and to ... shrink the physical size of database data and transaction log files. ...
    (comp.databases.ms-sqlserver)
  • Re: Cant shrink transaction log
    ... How to Shrink the SQL Server 7.0 Transaction Log ... INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE ...
    (microsoft.public.sqlserver.server)