Hi!
I attempted to backup a database on server x and restore it on a database on server y. The details are as follows.

Server X
Database name : dbx
Size :263.88MB (Unrestricted filegrowth option set)
Logical files : dbx_data, dbx_log
Physical files : e:mssql7datadbx_data.mdf, f:databaselogsdbx_log.ldf

Server Y
Database name : dby
Size :1MB (Unrestricted filegrowth option set)
Logical files : dby_data, dby_log
Physical files : d:mssql7datadby_data.mdf, d:mssql7datadby_log.ldf


I created a full database backup of dbx on server x at the location, f:ackupsdbx_083099_10.30AM. The size of the file is 272MB. I zipped the file. Copied the file, dbx_083099_10.30AM.xip over to d:ackups of server y. I unzipped the file at server y to the location, d:ackupsdbx_083099_10.30AMdbx_083099_10.30AM.

I now tried to restore this backup on server y using the statement,
restore database dby from disk = 'd:ackupsdbx_083099_10.30AMdbx_083099_10.3 0AM
with replace,
move 'dbx_data' to 'd:mssql7datadby_data.mdf',
move 'dbx_log' to 'd:mssql7datadby_log.ldf'


I get the following errors :

Server: Msg 3257, Level 16, State 1, Line 1
There is insufficient free space on disk volume 'd:' to create the database. The database requires 3219128320 additional free bytes, while only 2047102976 bytes are available.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally.

Error log shows,
1999-08-30 10:28:54.68 kernel BackupDiskFile::OpenMedia: Backup device 'd:ackupdbx_083099_10.30AMdbx_083099_10.30AM& #39; failed to open. Operating system error = 1326(Logon failure: unknown user name or bad password.).

(or)

Cannot open backup device, 'd:ackupdbx_083099_10.30AMdbx_083099_10.30AM& #39;. Device error or device offline. See SQL Server error log for more info.
Backup or restore operation terminated abnormally.

How can I solve this problem ?

Praveena