Click here to Skip to main content
15,886,362 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Am i trying to restore a sql server 2000 database from a .bak file with this T-SQL code:
SQL
RESTORE DATABASE SomeDB
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\backupFile.bak'
WITH MOVE 'db1_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\db1_Data.MDF',
    MOVE 'db1_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\db1_Log.LDF'

I keep receiving this error:

MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file.

SQL
RESTORE FILELISTONLY
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\F30AxleLine.bak'

tells me that the mdf has a size of 32519946240, a maxsize of 35184372080640 and the ldf has a size of 524812288 and a maxsize of 35184372080640. I currently have 180GB free space available so i do not believe this is actually a space issue.

I do not have the original mdf or the ldf files before the backup was made, so I cannot take another backup.

What am I doing wrong here?
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900