October 28, 2008 at 5:55 am
how to shrinking the database in sqlserver
what is the query using the shirinking the database
October 28, 2008 at 6:13 am
check out Shrink database in Books Online !
(or shrink file if you only want to do a single file)
Be aware that this will interfere with ongoing operations !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 28, 2008 at 6:47 am
Why are you shrinking your database?
Be aware that you will need to rebuild indexes afterwards as the shrink will badly fragment them.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 28, 2008 at 7:37 am
and after the rebuild, you'll have your "wasted space" back in your database .... 🙂
Wilfred
The best things in life are the simple things
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply