January 23, 2002 at 2:29 pm
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
January 23, 2002 at 3:17 pm
You can restore with move option. This allows you to move the log file.
Or buy a bigger disk.
Steve Jones
January 23, 2002 at 10:32 pm
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
Always Learn!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply