Reduceing the filesize of datafiles

Hi,
in the enterprise manger I want to reduce the datafiles of a database. When
I do this the enterprise manager says,
that there are 80% (more then 17GB), that can be freed, but after the cleani
ng process the datafiles would not be
shorter then before.
How can I clean the freeable memory of the datafiles ?
Is there an other way that works better ?
Best regards
Axel LanserAlex
Look at DBCC SHRINKDATABASE or DBCC SHRINKFILE in the BOL.
"Axel Lanser" <anonymous@.discussions.microsoft.com> wrote in message
news:EDD50E53-D546-4F24-90EB-674C0172361C@.microsoft.com...
> Hi,
> in the enterprise manger I want to reduce the datafiles of a database.
When I do this the enterprise manager says,
> that there are 80% (more then 17GB), that can be freed, but after the
cleaning process the datafiles would not be
> shorter then before.
> How can I clean the freeable memory of the datafiles ?
> Is there an other way that works better ?
> Best regards
> Axel Lanser|||Hi,
Did you meant "How to reduce the datafile size", If yes then execute the
below command in query analyzer,
DBCC SHRINKFILE('logicalfilename','truncateon
ly')
If it is TX log file, perform a 'Backup LOG' before shrinking the file.
Refer the below link for more info.
http://www.sql-server-performance.c...p?TOPIC_ID=3140
Thanks
Hari
"Axel Lanser" <anonymous@.discussions.microsoft.com> wrote in message
news:EDD50E53-D546-4F24-90EB-674C0172361C@.microsoft.com...
> Hi,
> in the enterprise manger I want to reduce the datafiles of a database.
When I do this the enterprise manager says,
> that there are 80% (more then 17GB), that can be freed, but after the
cleaning process the datafiles would not be
> shorter then before.
> How can I clean the freeable memory of the datafiles ?
> Is there an other way that works better ?
> Best regards
> Axel Lanser|||Hi,
I have made a 'backup log' before I start the dbcc shrinkfile for the Log-Fi
le, but the Log-File wouldn't be reduce.
I think all active transaction must be proccessed, because the data base is
in single user mode and I was permanently
conected with this database and without any new transaction on this database
for two days.
Therfore I don't know why the Logfile is not reduceable.
Can you help me ?
What can I do ?
Thanks
Axel|||http://www.karaszi.com/sqlserver/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Axel Lanser" <anonymous@.discussions.microsoft.com> wrote in message
news:B15B5790-C11F-4D51-8D0E-64FA48EB0B48@.microsoft.com...
> Hi,
> I have made a 'backup log' before I start the dbcc shrinkfile for the
Log-File, but the Log-File wouldn't be reduce.
> I think all active transaction must be proccessed, because the data base
is in single user mode and I was permanently
> conected with this database and without any new transaction on this
database for two days.
> Therfore I don't know why the Logfile is not reduceable.
> Can you help me ?
> What can I do ?
> Thanks
> Axel