dbTalk Databases Forums  

SQL 2005 - truncate or delete + backup not releasing datafile space?

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.server SQL 2005 - truncate or delete + backup not releasing datafile space?

microsoft.public.sqlserver.server microsoft.public.sqlserver.server


Discuss SQL 2005 - truncate or delete + backup not releasing datafile space? in the microsoft.public.sqlserver.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ziga Jakhel
 
Posts: n/a

Default SQL 2005 - truncate or delete + backup not releasing datafile space? - 12-02-2005 , 07:21 AM





Hi!

I have a problem with SQL 2005. I need to clear my database of all data, so
I went and truncated all tables.
OK. Select returnt 0 rows.

When I check the truncated tables in the Management Studio, the MS reports
several 1000 rows (as were before the truncate), and shrink database reports
the datafile of cca 200 megs.

wtf? This used to work in 2000...

Regards,

Ziga



Reply With Quote
  #2  
Old   
Ziga Jakhel
 
Posts: n/a

Default Re: SQL 2005 - truncate or delete + backup not releasing datafile space? - 12-02-2005 , 07:35 AM





Also... there are some ntext and image fields in the db which account for
most of the content.

Any ideas?

"Ziga Jakhel" <ziga(dot)jakhel(at)rrc.si> wrote

Quote:
Hi!

I have a problem with SQL 2005. I need to clear my database of all data,
so I went and truncated all tables.
OK. Select returnt 0 rows.

When I check the truncated tables in the Management Studio, the MS reports
several 1000 rows (as were before the truncate), and shrink database
reports the datafile of cca 200 megs.

wtf? This used to work in 2000...

Regards,

Ziga



Reply With Quote
  #3  
Old   
Ziga Jakhel
 
Posts: n/a

Default Re: SQL 2005 - truncate or delete + backup not releasing datafile space? - 12-02-2005 , 07:47 AM


Drop and recreate table worked though....

This really smells of some stray data to me...

"Ziga Jakhel" <ziga(dot)jakhel(at)rrc.si> wrote

Quote:
Hi!

I have a problem with SQL 2005. I need to clear my database of all data,
so I went and truncated all tables.
OK. Select returnt 0 rows.

When I check the truncated tables in the Management Studio, the MS reports
several 1000 rows (as were before the truncate), and shrink database
reports the datafile of cca 200 megs.

wtf? This used to work in 2000...

Regards,

Ziga



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top