Assigned Space

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. HelpDavid
Can you show us your DDL ?
"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|||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|||DBCC SHRINKDATABASE('dbname')
If this does not reduce the space, then that is the
minimum space required for storing the data in the
database, which can not be reduced unless you delete the
data (or truncate the log, in case of .ldf file).
regds,
Shrikant Patil
MCDBA
>--Original Message--
>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
>.
>