August 6, 2009 at 5:04 am
Is it possible to take full database backup of log shipped database (one that receives and applies logs from master)?
August 6, 2009 at 5:29 am
Is it possible to take full database backup of log shipped database (one that receives and applies logs from master)?
Do you mean the database on secondary server. In which mode did you configure logshipping.
No Recovery or Standby.
[font="Verdana"]Thanks
Chandra Mohan[/font]
August 6, 2009 at 5:39 am
Yes, I want to backup database on secondary server.
I still didn't configured it at all, I just asking if it is possible, in any mode, standby or no recovery.
August 6, 2009 at 7:42 am
I just asking if it is possible, in any mode, standby or no recovery.
In norecovery mode its not possible as db will be in recovery mode and you cannot access it.
In standby mode I think there are certain limitations.
If the time taken for backup is more than the restoration time I think it wont allow you.
If time taken for backing the secondary database is 20 mins and if you are restoring the tlogs for every 15 mins then i think its not possible. But I did not try this scenario. I will try it and let you know.
[font="Verdana"]Thanks
Chandra Mohan[/font]
August 6, 2009 at 7:46 am
Chandra,
Thank you very much!
I am waiting for your response...
August 6, 2009 at 9:13 am
You cannot backup a database in standby either. The restore process must be 100% complete before you can run a backup.
August 7, 2009 at 1:18 pm
Hi,
Jamie thanks for the info. I agree with you. Backup of secondary database whether in standby or norecovery mode fails. Only alternate option is database snapshot. But it works only on the instance where the secondary database resides and with enterprise edition only and there are certain other limitations like read only etc.. .
[font="Verdana"]Thanks
Chandra Mohan[/font]
August 7, 2009 at 2:04 pm
Hi,
Just checked the logshipping. Restore process is failing with the following error.
2009-08-08 01:15:02.06 *** Error: Could not apply log backup file '\\chandu\d$\sss\mydb_20090807191502.trn' to secondary database 'mydb_logshipping'.(Microsoft.SqlServer.Management.LogShipping) ***
2009-08-08 01:15:02.06 *** Error: The operation cannot be performed on a database with database snapshots or active DBCC replicas.
RESTORE LOG is terminating abnormally.(.Net SqlClient Data Provider) ***
[font="Verdana"]Thanks
Chandra Mohan[/font]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply