Restore - SQL Error 3257

vad2319

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

Eddie D

Thank you for your post into the forum.

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