You might want to check the MSKB. I'm thinking that you cannot restore a database to an external drive like this.
-Mike
>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