February 1, 2013 at 4:56 am
I just checked with developers they do archieving of data every quarter, so i dont tyhink it will grow more than 25GB...
Will execute the
ALTER DATABASE runal_jagtap MODIFY FILE (NAME = 'runal_jagtap_data', SIZE = 50GB)
after shrink & rebuild.. Thanks Anthony
Just a quick question, does it have anything to do with good performance or something else?? after alter activity is performed?
************************************
Every Dog has a Tail !!!!! :-D
February 1, 2013 at 4:59 am
If it never grows more than 25gb dont set it to 50GB your wasting 25GB of space that will never be used. Set it to something like 30GB so it has a bit of extra space.
But if the DB is 25GB now, just leave it alone, dont even bother shrinking it.
The only benefit would be to give the space back to the OS. But SQL will only take the space back so there is no point doing anything with the databases.
February 1, 2013 at 5:27 am
OK, thanks Anthony for your valuable replies 🙂
************************************
Every Dog has a Tail !!!!! :-D
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply