May 8, 2013 at 10:34 pm
We have configured the log shipping.
here backup job and copy jobs are working fine but restoring is not happening in secondary server
what could be the reason
May 9, 2013 at 4:00 am
It could be any number of things. Your best bet is to look at the error log and the execution log of your mirroring operation in SQL Agent. There's no way for me to suggest an answer without more data.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 9, 2013 at 9:40 am
New persopn (5/8/2013)
We have configured the log shipping.here backup job and copy jobs are working fine but restoring is not happening in secondary server
what could be the reason
You likely have t-log backups occurring on the primary outside of the LS jobs which are not being copied to the secondary. The restore is failing as the files are being skipped. Check carefully the restore job step history and post details back.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 9, 2013 at 12:09 pm
What is the state of database in secondary server? If it is in Standby mode, have you checked the Checkbox "Disconnect uses in the databse when restoring backup"
May 10, 2013 at 2:00 am
New persopn (5/8/2013)
We have configured the log shipping.here backup job and copy jobs are working fine but restoring is not happening in secondary server
what could be the reason
Hi,
Better you share the error log to understand the exact issue....
Satish
May 13, 2013 at 6:07 am
Hi
there is any number of reasons, like the agent can not access to log backup to restore or you are using the secondary database and database is in Use .
for help us and you , share the error log .
.
.
shayan
May 16, 2013 at 10:38 am
you have to need check errorlog for this issue
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply