| Author |
Topic |
|
balakrishnachow
Starting Member
24 Posts |
 Posted - 2010-10-10 : 13:37:16
|
| hi,can you help me. i created the database with initial size 2gb.after that it show in my system low disk space in that drive.but i dont need that much of space for that database.can you tell me how i can reduce the size of the database which i have already created with out shrink.Thanks,Balakrishna.good |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-10-11 : 13:22:20
|
tell me how i can reduce the size of the database which i have already created with out shrinkShrink without shrink?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
balakrishnachow
Starting Member
24 Posts |
Posted - 2010-10-11 : 13:58:57
|
| Hi,i tried that shirnking but it won't reflect to the size of the databasei got the solution for this issue.to reduce the initial size of the db we need to login with minimal congiguration and reduce the size what ever we want.ThanksBalakrishna.Bgood |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
balakrishnachow
Starting Member
24 Posts |
Posted - 2010-10-11 : 14:33:21
|
| hi,i have already tried for shrinking of that db but it wont reduces the initial size of the db.sorry i made a mistake with that minimal configuration also we are unable to solve the issue just now i tried.is there any chance to reduce the initial size of the dba witch i have already created.pls dont mistaken me because i don't no some thing about sqlserver just i started my carier with sqlserverdbaThankbalakrishna.bgood |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-11 : 14:44:24
|
| make sure you're using SHRINKFILE and not SHRINKDB |
|
|
|
balakrishnachow
Starting Member
24 Posts |
Posted - 2010-10-11 : 14:50:16
|
| hi,shrinking na it will compress the data in that db but what i am asking is can we reduce the size of the db with out shrinking.already lot of space in that db.(it is in 2005 sqlserver)thanksbalakrishna.bgood |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
balakrishnachow
Starting Member
24 Posts |
Posted - 2010-10-11 : 15:13:57
|
| hi,in sqlserver2008 we will reduce the size of the db with out shrinking i got some information which i got one of my friend from Microsoft.may be i will try in 2008 sqlserver.he said to me that its a bug in sqlserver2005.if any information needed i will ask to you.thanks for your assistence.thanksbalakrishna.bhere is the clear explanationi have created a new database with 2gb memory in a drive.after that the disk shows 'low disk space'.i.e no space in that drive.but space for that db is available up 1.9 gb.i thought that i need to reduce the size of the db.if i go for shrinking it show same space which i have created for the db.ok i will do the shrinking when the db is going beyond the limit or with the limit.but my question is that is there any way to reduce the size of the db with out going for srinking.if pls tell me the solution.please don't mind if i am geetting confued.but i need some clarification on that. ThanksBalakrishna.Bgood |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
balakrishnachow
Starting Member
24 Posts |
Posted - 2010-10-11 : 15:22:02
|
| hi,but here no need to run dbcc shrink right.when we are going for shrink? if the db is growing beyond the limint we will run right. then how we will reduce the size of db?ThanksBalakrishna.Bgood |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
balakrishnachow
Starting Member
24 Posts |
Posted - 2010-10-11 : 15:30:50
|
| hi,i dont have sqlserver2008 in my system tommorow i will check in my office and i will reply to that sorry if you get iritaion about my issue.it almost 2.00am here i need to go for sleep.i will catch you later bye tcthanksbalakrishna.bgood |
|
|
|
balakrishnachow
Starting Member
24 Posts |
Posted - 2010-10-12 : 09:02:44
|
| hi tara,can you give me any updates on this issue.thanksbalakrishnagood |
|
|
|
|
reducing the size of the db