Error on Restoring Database

Hi All,
We are trying to restore a database from a live system to our test system.
However, we are receiving the following errors when attempting to perform
this restore
"Modify file encountered operating system error 112(error code not found)
while attempting to expand the physical file
Cound not adjust the space allocation for file FILENAME"
I have tried searching online for this, but have had no luck. Also, when we
perform a restore of the backup from the test system this works fine.
Any help will be most appreciated
Richard,
Sounds like you might using a disk that was formatted for FAT32. Have you
checked that? FAT32 will only allow file sizes up to 4GB.
Mike C.
"Richardw" wrote:

> Hi All,
> We are trying to restore a database from a live system to our test system.
> However, we are receiving the following errors when attempting to perform
> this restore
> "Modify file encountered operating system error 112(error code not found)
> while attempting to expand the physical file
> Cound not adjust the space allocation for file FILENAME"
> I have tried searching online for this, but have had no luck. Also, when we
> perform a restore of the backup from the test system this works fine.
> Any help will be most appreciated
|||Hi,
Our discs are only ever formatted in NTFS
"MACason" wrote:
[vbcol=seagreen]
> Richard,
> Sounds like you might using a disk that was formatted for FAT32. Have you
> checked that? FAT32 will only allow file sizes up to 4GB.
> Mike C.
> "Richardw" wrote:
|||it seems too easy, but: did you verify the space allocation requirements for
the database? Are the permissions on the file system of the test environment
alright?
The message is referable to the SQL Server error 3140, and the possible
causes could be: lack of space on the disk, wrong name of the file, porblems
with the transaction log file; search for SQL Server error 3140 (Google it!)
Gilberto
"Richardw" wrote:

> Hi All,
> We are trying to restore a database from a live system to our test system.
> However, we are receiving the following errors when attempting to perform
> this restore
> "Modify file encountered operating system error 112(error code not found)
> while attempting to expand the physical file
> Cound not adjust the space allocation for file FILENAME"
> I have tried searching online for this, but have had no luck. Also, when we
> perform a restore of the backup from the test system this works fine.
> Any help will be most appreciated
|||Hi Gilberto,
Thanks for this, I had just noticed that the disc was seriously short on
space and am just trying to clear some, hopefully it will reolve the issue
"Gilberto Zampatti" wrote:
[vbcol=seagreen]
> it seems too easy, but: did you verify the space allocation requirements for
> the database? Are the permissions on the file system of the test environment
> alright?
> The message is referable to the SQL Server error 3140, and the possible
> causes could be: lack of space on the disk, wrong name of the file, porblems
> with the transaction log file; search for SQL Server error 3140 (Google it!)
> Gilberto
> "Richardw" wrote: