There is no space in the server

Question

Post reply

There is no space in the server

Viewing 6 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

parthi-1705 SSCrazy Eights Points: 9277 More actions · Answer 1

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

SQLRNNR SSC Guru Points: 281344 More actions · Answer 2

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

mlomas76 Newbie Points: 1 More actions · Answer 3

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.

parthi-1705 SSCrazy Eights Points: 9277 More actions · Answer 4

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

homebrew01 SSC Guru Points: 55555 More actions · Answer 5

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.

Steve Jones - SSC Editor SSC Guru Points: 738917 More actions · Answer 6

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