You can execute the LOAD statement to restore from a diskette, but the console command-line utility must be used to prompt the user and then wait for responses. If console is not running or if the user does not answer its questions, the load cannot proceed.
For information about running console and loading from a diskette dump device, see the Microsoft SQL Server Transact-SQL Reference.