August 27, 2010 at 10:24 am
CirquedeSQLeil (8/27/2010)
There are multiple ways to add disk space and have the data use the new space. One method is to extend your partition.
Even for partition we need to restart the server ,Without restating server is any way there :exclamationmark:
How can i add more space without restarting the server,only needed datas are there in those drives no unnecessary data is there
Thanks
Parthi
Thanks
Parthi
August 27, 2010 at 10:55 am
parthi-1705 (8/27/2010)
CirquedeSQLeil (8/27/2010)
There are multiple ways to add disk space and have the data use the new space. One method is to extend your partition.
Even for partition we need to restart the server ,Without restating server is any way there :exclamationmark:
How can i add more space without restarting the server,only needed datas are there in those drives no unnecessary data is there
Thanks
Parthi
Without restarting the server is an unrealistic option in the event that you have filled up your drive.
Think about it - if your drive is full, you are possibly halted on servicing transaction requests. Your goal is to get the server back to a state where it can service these requests.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 27, 2010 at 1:47 pm
Not making any assumptions, so have you checked to see if there are any other files or folders that you can delete? Emptying the recycle bin, deleting any update files that you may have downloaded to this drive, deleting anything in the windows temp folders, etc. Anything that isn't necessary so that you can have enough space to run your scripts to shrink the DB.
August 27, 2010 at 1:59 pm
mlomas76 (8/27/2010)
Not making any assumptions, so have you checked to see if there are any other files or folders that you can delete? Emptying the recycle bin, deleting any update files that you may have downloaded to this drive, deleting anything in the windows temp folders, etc. Anything that isn't necessary so that you can have enough space to run your scripts to shrink the DB.
Hi
You have given one of the possiable way.nice
Main thing i need to know is whether we can add a additional drive
Goal is to bring back the database to working condition
Thanks
Parthi
Thanks
Parthi
August 27, 2010 at 2:22 pm
Have you determined you need an extra drive ? If the log file grew to 100 G, and other junk got placed on the drive, then cleaning up & fixing the problems may resolve the space issue.
August 27, 2010 at 4:07 pm
homebrew01 has a good point. Check free space in logs/data files, and see if you can make some.
However if you are truly out of space and need to extend things, there will be a restart. If you add a file to a filegroup, the server can just start adding data to it. http://msdn.microsoft.com/en-us/library/ms189253.aspx
Viewing 6 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply