logging of shrinking

Question

logging of shrinking

Alex Huth

SSC Enthusiast

Points: 111
More actions
July 28, 2005 at 3:08 am

#186862

I´m new to MS SQL Server and have just shrinked the master. Is this action logged everywhere? Can´t see it in the logfile in Enterprise Manager.
Thanks in advance

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 1

Hi Alex,

Whilst I dont know if it's logged anywhere I would like to say that shrinking databases for the sake of it is false economy, when you rebuild an index on a user table it needs empty space in order to run properly.

I don't know if there was a massive problem with your master database being huge (a perfectly valid reason for shrinking it) but I tend to ensure there's enough room for at least 6 months growth in each of my databases to reduce OS fragmentation.

If space is becomming an issue then it would be better to arrange to get more capacity now rather than tinker round the edges like this.

Hope I haven't put you off or offended you here, that was not my intention, but you said you were new to SQL so this is something that you might not have known

Welcome to the best group in the world

Alex Huth SSC Enthusiast Points: 111 More actions · Answer 2

Thanks Veteran!

Indeed there was no problem with the master. I am busy with learning the SQL stuff and just come to the point of shrinking. First thing i thought about is if i can see it anywhere.

Alex

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 3

Just a pointer or two moving forward ...

Whenever you 'want to try comething out' use the pubs or Northwind databases (that's what they are there for). Sometimes 'trying something out' on a system database (master, model, msdb, tempdb) can have serious consequences (unless you want to practice recovering your server !). I would be remiss if I did not also mention that you should practice the 'religon' of backing up your database before trying anything 'new'. Good luck and have fun !!!

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

DCPeterson SSCoach Points: 15266 More actions · Answer 4

Funny thing that Rudy should mention backups, because it is really only in the backup history that you can track changes to the size of your databases, that is unless you have setup an automated process to monitor the size of your databases...

/*****************

If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

*****************/