Problems restoring a diff backup
Mr BoBo
Posts: 2
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.
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.
