August 5, 2002 at 6:57 am
I've been trying to reastore a database,
The backup file is 1.5GB. (there was about 850MB in data file and the rest was in a log file)
When restoring with:
USE master
GO
RESTORE DATABASE teenfx
FROM disk = 'g:\08042002.dat'
WITH MOVE 'fx_data' TO 'c:\MSSQL7\data\fx_data.mdf',
MOVE 'fx_log' TO 'c:\MSSQL7\data\fx_log.ldf'
go
I get an error:
There is insufficient free space on disk volume 'c:\' to create the database. The database requires 9996795904 additional free bytes, while only 6195381760 bytes are available.
Why is it asking for 10GB of free space (which I don't have!!!) when the original files take only 1.5 GB?? What can I do? I'm not a DB admin so I have no clue how to get arround it?
August 5, 2002 at 9:35 am
Try restoring with no log. I'm surprised it wants so much temp space, but it may be a check of x times the size as a just in case.
Steve Jones
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply