Post reply

Could not adjust the space allocation for log file in sql server 2000

  • April 16, 2007 at 4:46 am

    #370496

    Hi,

     

    When I am trying to restore the database in sql server 2000 i am getting the error that

    Modify file encountered operating system error 112(there is not enough space on the disk.)

    Whilw attempting to expand the physical file.

    Could not adjust the space allocation for database log file

    RESTORE DATABASE is terminating abnormally.

     

    Can you please guide how to rectify this problem.

    I am not able to restore the database.

     

     

  • April 16, 2007 at 8:48 am

    #700701

    Hello,

    It seems there is no space on the disk to which you are trying to restore the database. Either you need to make up some space by deleting un-wanted files on that drive or else you need to find another disk / system to which you can restore this database.

    Hope this routes you in the right direction.

    Thanks

     


    Lucky

  • April 24, 2007 at 5:59 am

    #702126

    As Lucky said, find an another specious disk and RESTORE the database with MOVE (MOVE 'logical_file_name' TO 'operating_system_file_name) option that will help to move the data and log files in the desired destinition. To find the file details in the backup, use the RESTORE FILELISTONLY.

    Thanks
    Jay
    http://www.sqldbops.com

Viewing 3 posts - 1 through 2 (of 2 total)

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