Restore - SQL Error 3257
vad2319
Posts: 40
I am trying to evaluate SQL Backup v5. I tried to setup log shipping for a database(60 GB). I find that the backup completes successfully in the shared folder, however the restore fails. Below is the message that I get:
*********************************************************
Setting up log shipping - Failed
================================
Backing up source database - Successful
This operation completed successfully.
Backing up CTSY2K (full database) to:
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\SEED_CTSY2K_20071227113609.sqb
Database size : 58.214 GB
Compressed data size: 4.028 GB
Compression rate : 93.08%
Processed 2743144 pages for database 'CTSY2K', file 'CTSY2K_dat' on file 1.
Processed 19 pages for database 'CTSY2K', file 'CTSY2K_log' on file 1.
BACKUP DATABASE successfully processed 2743163 pages in 346.292 seconds (64.893 MB/sec).
SQL Backup process ended.
Restoring database to destination server - Failed
This operation failed with errors.
Restoring CTSY2K_2 (database) from:
\\drglendale\redgate\SEED_CTSY2K_20071227113609.sqb
SQL Server error
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3257: SQL error 3257: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 62506991616 additional free bytes, while only 10994490368 bytes are available.
SQL Backup exit code: 1100
SQL error code: 3257
Creating backup job - Pending
Operation pending.
Create restore job - Pending
Operation pending.
Refresh server information - Pending
Operation pending.
***************************************************
Please advise what should be done inorder for the restore to function right.
Thanks!
Vivek
*********************************************************
Setting up log shipping - Failed
================================
Backing up source database - Successful
This operation completed successfully.
Backing up CTSY2K (full database) to:
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\SEED_CTSY2K_20071227113609.sqb
Database size : 58.214 GB
Compressed data size: 4.028 GB
Compression rate : 93.08%
Processed 2743144 pages for database 'CTSY2K', file 'CTSY2K_dat' on file 1.
Processed 19 pages for database 'CTSY2K', file 'CTSY2K_log' on file 1.
BACKUP DATABASE successfully processed 2743163 pages in 346.292 seconds (64.893 MB/sec).
SQL Backup process ended.
Restoring database to destination server - Failed
This operation failed with errors.
Restoring CTSY2K_2 (database) from:
\\drglendale\redgate\SEED_CTSY2K_20071227113609.sqb
SQL Server error
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3257: SQL error 3257: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 62506991616 additional free bytes, while only 10994490368 bytes are available.
SQL Backup exit code: 1100
SQL error code: 3257
Creating backup job - Pending
Operation pending.
Create restore job - Pending
Operation pending.
Refresh server information - Pending
Operation pending.
***************************************************
Please advise what should be done inorder for the restore to function right.
Thanks!
Vivek
Comments
Your SEED Restore job of the Log Shipping set up is failing as there is insufficient disk space on the SQL Server you are restoring too, for the server to create the database, hence why it is creating this error:
SQL error 3257: SQL error 3257: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 62506991616 additional free bytes, while only 10994490368 bytes are available.
If you wish to set up log shipping to this server, you must choose another disk volume with sufficient disk space or add another disk volume to the server in excess of 63GB or use another server with sufficient disk space.
Many Thanks
Eddie
Eddie davis
Technical Support Engineer
Red Gate Software Ltd
e-mail: support@red-gate.com
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com