MODIFY FILE encountered operating system error 112(

Last post 11-21-2008 1:32 PM by MohammedU. 1 replies.
Page 1 of 1 (2 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 11-21-2008 10:23 AM

    MODIFY FILE encountered operating system error 112(

    hI I am getiing below error while i am doing restore .
    i know i have more than 50 gb of space on disk but my
    mdf size 5 gb and ldf size 6 gb .total togather 11gb
    why i got this error.really did not understand it is operationg
    system error or disk error.Provide some info
    \see eerror below
    MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file.

  • 11-21-2008 1:32 PM In reply to

    Re: MODIFY FILE encountered operating system error 112(

    May be at the time of backup , your file sizes were different.

    Check the file sizes in the backup file by running RESTORE FILELISTONLY command...

    RESTORE FILELIST ONLY FROM DISK = 'C:\BACKUPFILE.BAK'

    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
Page 1 of 1 (2 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.