There is no space in the server

  • 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

  • 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

  • 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.

  • 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

  • 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.

  • 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