November 22, 2003 at 12:48 pm
I currently administer a db that by error in inputting photos grew to an unmanageable size. After deleting thousands of jpegs, using the shrink utility did not seem to be reclaiming porportionate space. I ran the shrink file utility and when completed, it showed no space(0%). I'm not sure of what this means, as all services seem to be functioning. Any guidance will help...
November 24, 2003 at 1:12 am
What is an 'unmanageable size'?
Did you backup db and logs?
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 24, 2003 at 3:57 am
The size is 48GB. & GB is data and the rest is photos we are trying to change from in the DB to a link instead. DB and logs were backed up...
November 24, 2003 at 4:26 am
Try running DBCC UPDATEUSAGE in QA for the database in question. It updates the space used displayed in EM. I have had problems with zero space which have been fixed with this.
Jeremy
November 24, 2003 at 4:28 am
this one goes to you, Jeremy!
was just typing when I heard your mail coming in...
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 24, 2003 at 4:40 am
Frank,
This came up in a thread a few weeks ago but I still don't know why the space used goes screwy. Do you?
Jeremy
November 24, 2003 at 4:45 am
No, after running the usual things like DBCC CHECKDB, UPDATEUSAGE.....I have no idea.
I know that EM uses an undocumented DBCC command
DBCC SHOWFILESTATS
to show its graphic when set to Taskpad view.
But that's all.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply