We have been using SQL (6.5, 7.0, and 2000) for several years as a backend to VFP, but we are novices in SQL administration - so please do not assume we know what we are doing!
One of our developers just got an external 200GB FireWire drive. He wants to have a copy of the production database on it so he can take it home and develop there also.
1. We copied the backup file to the \Backup directory on external hard drive
2. We issued the below in 'Query Analyzer'
RESTORE DATABASE bbsqllocal
FROM DISK = 'F:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Slaughter_db_200302052100.BAK'
with move 'slaughter' TO 'F:\Program Files\Microsoft SQL Server\MSSQL\data\Slaughter.mdf',
MOVE 'slaughter_log' TO 'F:\Program Files\Microsoft SQL Server\MSSQL\data\Slaughter_log.ldf'
and we get the below error messages:
Server: Msg 5149, Level 16, State 1, Line 2
MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file.
Server: Msg 3158, Level 16, State 1, Line 2
Could not create one or more files. Consider using the WITH MOVE option to identify valid locations.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
We are puzzled by the error 5149 (not enough free space) since there is over 180GB (that's GigaBytes) and the original file is only about 5GB in size.
Any help would be appreciated.
Dennis Schuette
Brawley Beef, LLC
Dennis Schuette