Restore database - error 3257- Out of DiskSpace

• mikelnelson

  SSC Veteran

  Points: 231

  More actions

  January 23, 2002 at 2:29 pm

  #151655

  Problem with restore database.

  <<< script command(s)

  RESTORE FILELISTONLY

  FROM DISK = 'f:\SQL-1-~1\STROMB~3.BAK'

  GO

  RESTORE VERIFYONLY

  FROM DISK = 'f:\SQL-1-~1\STROMB~3.BAK'

  GO

  RESTORE DATABASE stromberg_Data

  FROM DISK = 'f:\SQL-1-~1\STROMB~3.BAK'

  WITH NORECOVERY,

  MOVE 'stromberg_Data' TO 'F:\amat\MSSQL\Data\stromberg_Data.MDF',

  MOVE 'stromberg_Log' TO 'F:\amat\MSSQL\Data\stromberg_Log.LDF'

  GO

  <<<<end of script

  <<<<results of script

  1 stromberg_Data D:\Program Files\Microsoft SQL Server\MSSQL\data\stromberg_Data.MDFDPRIMARY13218611235184372080640

  2 stromberg_Log D:\Program Files\Microsoft SQL Server\MSSQL\data\stromberg_Log.LDFLNULL635502592035184372080640

  (2 row(s) affected)

  Server: Msg 3257, Level 16, State 1, Line 5

  There is insufficient free space on disk volume 'F:\' to create the database. The database requires 6487212032 additional free bytes, while only 919869440 bytes are available.

  Server: Msg 3013, Level 16, State 1, Line 5

  RESTORE DATABASE is terminating abnormally

  <<<<< end of results

  I have only 4.5gb of free disk space. Is there a way to just restore the .mdf file (I have enough disk space for this file) ?

  If not, can the script/command be told to continue (i know i will run out of disk space), so I will have just the one mdf file?

  thanks for any/all help!

  Mike

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737981

  More actions

  January 23, 2002 at 3:17 pm

  #422562

  You can restore with move option. This allows you to move the log file.

  Or buy a bigger disk.

  Steve Jones

  steve@dkranch.net

• cabby2583

  SSC-Addicted

  Points: 460

  More actions

  January 23, 2002 at 10:32 pm

  #422575

  If you're using Win98, there's a bug. Check out the following KB article (Q273833), on Microsoft TechNet:

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;q273833

  cabby2583

  caballero@mediaone.net

  Always Learn!