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 12»»

All the 3 jobs are running successfully but Restoration in Secondary server is not happening Expand / Collapse
Author
Message
Posted Friday, April 11, 2014 3:44 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 5:55 AM
Points: 163, Visits: 524
Dear All,
Am using 2008,
I have configured Log Shipping successfully.
All the 3 jobs are running successfully but the thing is after executing the Restoring Job the Transactions are not restoring in the Secondary Server.
Could you please help me out


Regards..


Regards
Chowdary...
Post #1560782
Posted Friday, April 11, 2014 6:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:22 AM
Points: 6,638, Visits: 14,221
although the restore job says its successful, check the history of each individual step, there'll be an error message there somewhere

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1560846
Posted Friday, April 11, 2014 6:26 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 5:55 AM
Points: 163, Visits: 524
Hi Sir,
I Have Checked all the Steps there was no failures in that
PFA..

Please help me out....


Regards
Chowdary...


  Post Attachments 
restorejob.jpg (7 views, 292.64 KB)
Post #1560856
Posted Friday, April 11, 2014 7:24 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:30 AM
Points: 509, Visits: 1,885
Two lines down in the screenshot you have a line that says 'Could not find a log backup file that could be applied to secondary database'. Have a look at that.
Post #1560896
Posted Friday, April 11, 2014 7:32 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 5:55 AM
Points: 163, Visits: 524
Yes Sir,
Now I checked that Message.

But how can i restore that files synchronously .the path also i have given correctly

For Backup Job Step i have given the Network path like(\\MERIX-PC\PrimaryDB)
and For Copy Job i have given that local folder path like(e:\Secondary).

Sir one thing here ,If I Run the Restore_Job manually then transaction are getting restoring
but its not working automatically.

Please help me out.....

Regards
Jagadeesh..


Regards
Chowdary...
Post #1560905
Posted Friday, April 11, 2014 7:56 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:30 AM
Points: 509, Visits: 1,885
Can you put the whole of that error message up here? The one that starts 'Could not find a log backup file that could be applied to secondary database'.
Post #1560935
Posted Sunday, April 13, 2014 10:12 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 5:55 AM
Points: 163, Visits: 524
Dear Sir ,
Good Morning..
Please find the below Message...This is the whole message of Restore Job.


Message
2014-04-11 18:25:01.04 Could not find a log backup file that could be applied to secondary database 'Secondary'.

2014-04-14 09:45:01.58 The restore operation was successful. Secondary Database: 'Secondary', Number of log backup files restored: 0

2014-04-14 09:45:01.60 Deleting old log backup files. Primary Database: 'Secondary' "

Note :Secondary is my Name of Secondary Database.

And one more thing am having doubt sir,
Here in this Log Shipping while am trying to check the Primary Database Details by using the following Command
"select * from msdb.dbo.log_shipping_monitor_primary" nothing is displaying, it is showing only the column names..

Ps help me out..

Regards
Jagadeesh...


Regards
Chowdary...
Post #1561319
Posted Monday, April 14, 2014 2:51 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:30 AM
Points: 509, Visits: 1,885
Go back to your primary and check that the backup job is running. Open the folder and check that the file is being placed where you expect. Basically, kick off the backup job and watch it put the file in the folder, then switch to the secondary, kick off the copy job and watch that it copies the file to the correct folder. Then if that works, manually kick off the restore job and watch that.

I would also check your file retention settings on the secondary as it may be that you are deleting them too soon. How often does each job run?
Post #1561373
Posted Monday, April 14, 2014 2:51 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:30 AM
Points: 509, Visits: 1,885
Sorry; I even switched browsers, and the duplicates keep happening.)
Post #1561374
Posted Monday, April 14, 2014 2:57 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 5:55 AM
Points: 163, Visits: 524
Hi Sir.

I Have Scheduled for every 15 min to all the Jobs.

Regards...


Regards
Chowdary...
Post #1561376
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse