Comments
Sort by recent activity
I see no indication of a log restore being attempted. / comments
I see no indication of a log restore being attempted.
I have the same results as mgjernes. The full and differentials restore but no logs applied and the database is left in the restoring state. / comments
I have the same results as mgjernes. The full and differentials restore but no logs applied and the database is left in the restoring state.
That must be it. That's the version I'm running. Many thanks. / comments
That must be it. That's the version I'm running. Many thanks.
Can't even run it locally. Can't replace xp_sqlbackup.dll :evil: / comments
Can't even run it locally. Can't replace xp_sqlbackup.dll :evil:
Just thought I'd bump this up. I try really hard to keep the noise down in my log files. The thousands of DBCC TRACEON 3604 are a bit annoying. / comments
Just thought I'd bump this up. I try really hard to keep the noise down in my log files. The thousands of DBCC TRACEON 3604 are a bit annoying.
Hey new error this time. It says it can't open the database because it's in the middle of a restore. Well, DUH. So, I get a log entry that says the differential restore failed, but right after that there is another one that says success and the database seems to be back online. It's really hard to read the activity history because the in the UI because the window is constantly flashing.
12/21/2009 1:04:19 PM: Restoring testrestore (database) on TEST_THOR instance from:
12/21/2009 1:04:19 PM: C:\Temp\New Folder\DIFF_(local)_Ektron_20091221_023020.sqb
12/21/2009 1:04:19 PM: ALTER DATABASE [testrestore] SET ONLINE RESTORE DATABASE [testrestore] FROM VIRTUAL_DEVICE = 'SQLBACKUP_5202888F-F2B9-45B2-8888-C1E23E8FD1FD', VIRTUAL_DEVICE = 'SQLBACKUP_5202888F-F2B9-45B2-8888-C1E23E8FD1FD01', VIRTUAL_DEVICE =
'SQLBACKUP_5202888F-F2B9-45B2-8888-C1E23E8FD1FD02', VIRTUAL_DEVICE = 'SQLBACKUP_5202888F-F2B9-45B2-8888-C1E23E8FD1FD03', VIRTUAL_DEVICE = 'SQLBACKUP_5202888F-F2B9-45B2-8888-C1E23E8FD1FD04', VIRTUAL_DEVICE = 'SQLBACKUP_5202888F-F2B9-45B2-8888-C1E23E8FD1FD0
5', VIRTUAL_DEVICE = 'SQLBACKUP_5202888F-F2B9-45B2-8888-C1E23E8FD1FD06' WITH BUFFERCOUNT = 28, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , RECOVERY
12/21/2009 1:04:22 PM: SQL Server error
12/21/2009 1:04:22 PM: SQL error 5069: SQL error 5069: ALTER DATABASE statement failed.
12/21/2009 1:04:22 PM: SQL error 927: SQL error 927: Database 'testrestore' cannot be opened. It is in the middle of a restore. / comments
Hey new error this time. It says it can't open the database because it's in the middle of a restore. Well, DUH. So, I get a log entry that says the differential restore failed, but right after t...
Chris Auckland wrote:
Thanks for your post.
Can you confirm the restore script you are using. I have seen this issue before when using the 'Kill existing connections' option in the restore script.
We have a bug open for that issue, which is fixed in the next release (SB-4446).
Can you try performing the FULL + DIFF restore without the 'kill existing connections' option and see if it helps?
The kill existing connections option didn't make any difference. The only way I can restore a differential with no issues is to do the full and diff in separate restores. I also had a restore last week that would not apply the differential backup at all no matter what I did. I'm really glad it was just a restore to dev and I wasn't relying on it. / comments
Chris Auckland wrote:
Thanks for your post.
Can you confirm the restore script you are using. I have seen this issue before when using the 'Kill existing connections' option in the restore scrip...
I guess I can't pick both the full and diff and do the restore of both at the same time. If I do them individually I don't get an error. / comments
I guess I can't pick both the full and diff and do the restore of both at the same time. If I do them individually I don't get an error.
I tried another restore the same way and it fails leaving the database in recovery mode. Here's the log
SQL Backup log file 6.3.0.48
-SQL "RESTORE DATABASE [testrestore] FROM DISK = 'C:\Temp\DIFF_(local)_Ektron_20091217_023020.sqb' WITH PASSWORD = 'xxxxxxxxxx', RECOVERY "
ERRORS AND WARNINGS
12/21/2009 12:46:12 PM: Restoring testrestore (database) on TEST_THOR instance from:
12/21/2009 12:46:12 PM: C:\Temp\DIFF_(local)_Ektron_20091217_023020.sqb
12/21/2009 12:46:12 PM: RESTORE DATABASE [testrestore] FROM VIRTUAL_DEVICE = 'SQLBACKUP_A3EB9BE6-9AE2-40EA-BA3C-3485980C5C9E', VIRTUAL_DEVICE = 'SQLBACKUP_A3EB9BE6-9AE2-40EA-BA3C-3485980C5C9E01', VIRTUAL_DEVICE = 'SQLBACKUP_A3EB9BE6-9AE2-40EA-BA3C-3485980
C5C9E02', VIRTUAL_DEVICE = 'SQLBACKUP_A3EB9BE6-9AE2-40EA-BA3C-3485980C5C9E03', VIRTUAL_DEVICE = 'SQLBACKUP_A3EB9BE6-9AE2-40EA-BA3C-3485980C5C9E04', VIRTUAL_DEVICE = 'SQLBACKUP_A3EB9BE6-9AE2-40EA-BA3C-3485980C5C9E05', VIRTUAL_DEVICE =
'SQLBACKUP_A3EB9BE6-9AE2-40EA-BA3C-3485980C5C9E06' WITH BUFFERCOUNT = 28, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , RECOVERY
12/21/2009 12:46:12 PM: SQL Server error
12/21/2009 12:46:12 PM: SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
12/21/2009 12:46:12 PM: SQL error 3136: SQL error 3136: Cannot apply the backup on device 'SQLBACKUP_A3EB9BE6-9AE2-40EA-BA3C-3485980C5C9E' to database 'testrestore'. / comments
I tried another restore the same way and it fails leaving the database in recovery mode. Here's the log
SQL Backup log file 6.3.0.48
-SQL "RESTORE DATABASE [testrestore] FROM DISK = 'C:\Temp\DIFF_...
RBA wrote:
Hi Steve,
When you use the restore wizard, step 1 gives you a drop down list of all the SQL Server instances you've registered with the application. If the server you wish to restore to is not on this list, you must first register it (File > Add SQL Server). Remember to change "Select from backup history" to "Browse for backups to restore" in step 1 or the wizard will only show backups from the selected test server.
Hope this helps,
I bet he wants to use the backup history of 1 server for the selections and have it restore to a different server. That would be kind of nice actually. / comments
RBA wrote:
Hi Steve,
When you use the restore wizard, step 1 gives you a drop down list of all the SQL Server instances you've registered with the application. If the server you wish to restore ...