February 14, 2011 at 12:28 am
Hi,
I am on v5 on Litespeed for SQL server, when I try this:
EXEC master.dbo.xp_backup_database @database = MyDB,
@filename = 'C:\Temp\mirror1\MyDB.bak',
@mirror = 'C:\Temp\mirror2\MyDB.bak',
@mirror = 'C:\Temp\mirror3\MyDB.bak'
My backup fails if folder mirror3 is not there. I am trying to simulate one of the mirrors failure here.
Has this been corrected in any later version of litespeed? Is there any way to tell litespeed continue with the backups if at least one of the destinations is available? I understand this is not possible at all using native backups?
Thanks.
February 14, 2011 at 1:14 pm
No, there is nothing in Litespeed that would do that - as far as I know.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 15, 2011 at 8:42 pm
Let me add some detail. We made a change to LiteSpeed some time back to not fail a backup if any of the mirrors fail. That functionality is in place now, with one caveat which I'll explain in moment. Currently, if you start a backup and during that backup any of the mirrors fail, the backup continues. It continues as long as the primary does not fail. The caveat, is that if the backup location is simply not available at backup time, the initialization process fails and that is causing the backup to fail. We are looking right now to address this in the next release in May. In the meantime, you can have some assurance that as long as the backup can be started, it will not fail as long as the primary succeeds.
If you can post your exact version, I can check to see if it supports this feature.
Thanks.
--
David Gugick
Dir. Architecture & Design, Quest Software
February 16, 2011 at 2:29 am
I will check the version tomorrow, when I come to the office.
Why does it have to be the primary only? I reckon, the backup should continue as long as one destination is available, because what if the primary fails? At least there should be a switch with this option.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply