Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restore is not happening Expand / Collapse
Author
Message
Posted Wednesday, May 8, 2013 10:34 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402

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


Post #1450879
Posted Thursday, May 9, 2013 4:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:38 AM
Points: 13,755, Visits: 28,147
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1450975
Posted Thursday, May 9, 2013 9:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:56 PM
Points: 6,365, Visits: 13,695
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"
Post #1451207
Posted Thursday, May 9, 2013 12:09 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 8:43 AM
Points: 820, Visits: 1,175
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"
Post #1451288
Posted Friday, May 10, 2013 2:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
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
Post #1451463
Posted Monday, May 13, 2013 6:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 5:06 AM
Points: 2, Visits: 77
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
Post #1452065
Posted Thursday, May 16, 2013 10:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 28, 2014 3:11 PM
Points: 8, Visits: 4
you have to need check errorlog for this issue
Post #1453668
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse