September 15, 2006 at 8:58 am
Hi Guys, I've this issue with the database size and the space available in sql server 2000. My databases are showing big amt of space available. For Ex. if i execute sp_spaceused on tempdb it gives me datatbase_size : 6GB and unallocated_space: 5.8GB. I tried to use shrinkdatabase, shrinkfile and also checked to move the pages to the beginning but no success. It still shows that huge amt of space is being used and/or occupied by the database. This is the case with most of the database. And some of our databases are even bigger than 30-40 GB. Any ideas to free this unused space for OS.
I think the problem started when our database was set to grow automatically by 10%.
Thanks for your help.
RS
September 18, 2006 at 11:46 am
tempdb should return to its starting size when you restart sqlserver.
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
September 19, 2006 at 11:59 am
Using DBCC SHRINKDATABASE the DB cannot be shrunk lesser than the size it was created so when the databases were created were they created with larger file size?
The database cannot be made smaller than the size of the model database.Is your model database bigger?
To reduce the size of database to a size lesser than it was created then use DBCC SHRINKFILE.
For all these to work you need to back up the database and run DBCC.
Thanks
Sreejith
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply