Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Shrink/Resize Database SQL Server 2005 64-Bit
18 views
Skip to first unread message
Baumi2003
Jun 1, 2010, 10:19:02 AM6/1/10
to
Hi, I've cleaned up many Tables in my Database (for example SysdatabaseLog)
and now over 50% of my database is empty. I've tried to resize the database
and the files over the contextmenue in the SQL Server Management Studio but
the mdb-file didn't get smaller. I also tried to do this by SQL with DBCC
SHRINKDATABASE (0, NOTRUNCATE ) and DBCC SHRINKDATABASE (0, TRUNCATEONLY ).
What else can I do? Is it because the startsize (properties -> files) is
nearly the same size as the mdb-file? I also did a reindex over the database.
and now over 50% of my database is empty. I've tried to resize the database
and the files over the contextmenue in the SQL Server Management Studio but
the mdb-file didn't get smaller. I also tried to do this by SQL with DBCC
SHRINKDATABASE (0, NOTRUNCATE ) and DBCC SHRINKDATABASE (0, TRUNCATEONLY ).
What else can I do? Is it because the startsize (properties -> files) is
nearly the same size as the mdb-file? I also did a reindex over the database.
Glibs
Jun 10, 2010, 6:45:40 PM6/10/10
to
> Is it because the startsize (properties -> files) is
> nearly the same size as the mdb-file?
> nearly the same size as the mdb-file?
This may be the reason.
Baumi2003
Jun 11, 2010, 7:28:32 AM6/11/10
to
And how can I change the start-size?
When I overwrite the size and click OK and open the window again, I get the
old size and nothing has changed.
When I overwrite the size and click OK and open the window again, I get the
old size and nothing has changed.
"Glibs" wrote:
> .
>
Glibs
Jul 3, 2010, 3:27:30 AM7/3/10
to
I do not know the way, so I waited if someone who knows replies.
If you will not find a way you may try to create new DB with correct size
and copy all the data into new DB. I used such a way to change DB collation.
Kenneth A. Larsen
Jul 8, 2010, 6:46:04 PM7/8/10
to
"Baumi2003" <Baum...@discussions.microsoft.com> wrote in message
news:5C681FE9-B884-4872...@microsoft.com...
But, you can do databases at Microsoft Office Access.
Kenneth A. Larsen
Jul 8, 2010, 6:46:34 PM7/8/10
to
"Glibs" <gl...@hotmail.com> wrote in message
news:uInvg7OC...@TK2MSFTNGP05.phx.gbl...
>> Is it because the startsize (properties -> files) is
>> nearly the same size as the mdb-file?
>
> This may be the reason.
>That is the reason.
DBA
Aug 31, 2010, 1:12:03 AM8/31/10
to
It is very late reply. but If u have same trouble, try to do this
DBCC SHRINKFILE (file_name, 10000)
ALTER DATABASE database_name
MODIFY FILE (
NAME = file_name,
SIZE = 10000 MB )
0 new messages