What are the challenges you face when working across database platforms? Take the survey
Options

Problems restoring a diff backup

Mr BoBoMr BoBo Posts: 2
edited August 18, 2008 7:39PM in SQL Backup Previous Versions
I tried to do a diff restore back to a new database.

I ran the restore of the diff and the full, using the Operational setting. The full completes successfully but the diff fails:

MyServer: Restore - Failed
=========================

Restoring full backup - Successful

This operation completed successfully.

Restoring NewDB (database) from:
z:\Old_DB\FULL_(local)_Old_DB_20080813_220100.sqb
Processed 1896 pages for database 'NewDB', file 'Old_DB_Data' on file 1.
Processed 3 pages for database 'NewDB', file 'Old_DB_Log' on file 1.
RESTORE DATABASE successfully processed 1899 pages in 0.078 seconds (199.391 MB/sec).
SQL Backup process ended.



Restoring differential backup - Failed

This operation failed with errors.

Restoring NewDB (database) from:
Z:\Old_DB\DIFF_(local)_Old_DB_20080815_000002.sqb
SQL Server error
SQL error 15247: SQL error 15247: User does not have permission to perform this action.
Processed 160 pages for database 'NewDB', file 'Old_DB_Data' on file 1.
Processed 3 pages for database 'NewDB', file 'Old_DB_Log' on file 1.
SQL Backup exit code: 1100
SQL error code: 15247



Updating SQL Server information - Pending

Operation pending.

I add my user ID (a domain admin and therefore an SA on SQL) to the DB as DBO.

I now attempt to restore the same full but as non-operational. It works but is left as non-operational. I restore just the diff as an operational restore and get the permission denied again. I read my ID and try to restore just the diff again and get the error below:

MyServer: Restore - Failed
=========================

Restoring differential backup - Failed

This operation failed with errors.

Restoring NewDB (database) from:
Z:\Old_DB\DIFF_(local)_Old_DB_20080815_000002.sqb
SQL Server error
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3117: SQL error 3117: The log or differential backup cannot be restored because no files are ready to rollforward.
SQL Backup exit code: 1100
SQL error code: 3117



Updating SQL Server information - Pending

Operation pending.
Sign In or Register to comment.