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. Help
David
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/de..._dbcc_8b51.asp
If this does not work check out :
http://msdn.microsoft.com/library/de...r_da2_1uzr.asp
and the following KB articles:
INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/default...b;en-us;256650
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/default...b;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
|||The SQL Server 2000 Resource kit provides a cut-down version of Log Shipping.
It doesn't use the functionality provided by Enterprise and is a lot simpler.
I think it's coded in VB, so should be usuable with the Standard edition.
Al

Assigned Space

Can anyone help?
I have assigned space to a file in Sql. I need to reduce the space but it w
ill 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:
b51.asp" target="_blank">http://msdn.microsoft.com/library/d...
b51.asp
If this does not work check out :
_1uzr.asp" target="_blank">http://msdn.microsoft.com/library/d...r />
_1uzr.asp
and the following KB articles:
INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/defaul...kb;en-us;256650
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/defaul...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|||The SQL Server 2000 Resource kit provides a cut-down version of Log Shipping
.
It doesn't use the functionality provided by Enterprise and is a lot simpler
.
I think it's coded in VB, so should be usuable with the Standard edition.
Al