Comments
Sort by recent activity
FYI - the error at the end of my last post was not from SQL Backup. It was from the USE [Database] statement at the end of my test script. SQL Backup's last result was "successful". I will re-do the script with profiler as requested when I get a chance, but I had to revert to release .0.56 on this server because the .1001 version was failing on larger log shipping restores (>8GB log change on 80GB DB after index rebuild) - it would start restoring, but would not complete, ever. Same with a full restore of the same DB.
I will "re-install" the 1001 files and try testing again, but I will have to set up a designated test server with a trial install to do so - no more "testing" on our production hot-spare log shipping system! / comments
FYI - the error at the end of my last post was not from SQL Backup. It was from the USE [Database] statement at the end of my test script. SQL Backup's last result was "successful". I will re-do...
I have been having a similar issue with the Latest_All switch on SQLBackup 6.4.0.56. In my case, the latest full backup would restore correctly but then the process would hang indefinitely, never starting the subsequent differential and/or log restores. I downloaded the patch listed in this thread and now I get a different issue. The full restore succeeds, but then any subsequent differential restores fail with the following errors:
SQL error 5069: ALTER DATABASE statement failed.
SQL error 5052: ALTER DATABASE is not permitted while a database is in the Restoring state.
I get this even if I use a full and differential backup generated from the same DB on the same server immediately prior to the restore attempt, as per the script below:
EXEC master..sqlbackup '-SQL "BACKUP DATABASE [FMP] To DISK = [E:\Temp\AMRSQLRepl_FMP_20100707_1536_Full.sqb] WITH CHECKSUM, COMPRESSION=4, KEYSIZE=128, PASSWORD=[pwd], VERIFY"'
GO
EXEC master..sqlbackup '-SQL "BACKUP DATABASE [FMP] To DISK = [E:\Temp\AMRSQLRepl_FMP_20100707_1536_Diff.sqb] WITH DIFFERENTIAL, CHECKSUM, COMPRESSION=4, KEYSIZE=128, PASSWORD=[pwd], VERIFY"'
GO
EXEC master..sqlbackup '-SQL "BACKUP LOG [FMP] To DISK = [E:\Temp\AMRSQLRepl_FMP_20100707_1537_Log.sqb] WITH CHECKSUM, COMPRESSION=4, KEYSIZE=128, PASSWORD=[pwd], VERIFY"'
GO
EXEC master..sqlbackup '-SQL "RESTORE DATABASE [FMP] FROM DISK = [E:\Temp\AMRSQLRepl_FMP*.sqb] LATEST_ALL WITH DISCONNECT_EXISTING, PASSWORD=[pwd], REPLACE"'
GO
All three backup stages completed normally, as did the full restore stage.
SQL server version is 9.0.4053. Script run under the "sa" account.
Suggestions?? / comments
I have been having a similar issue with the Latest_All switch on SQLBackup 6.4.0.56. In my case, the latest full backup would restore correctly but then the process would hang indefinitely, never ...