Restore - SQL Error 3257

vad2319vad2319 Posts: 40
edited December 31, 2007 7:46AM in SQL Backup Previous Versions
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

Comments

  • Eddie DEddie D Posts: 1,800 Rose Gold 5
    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.