SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


All the 3 jobs are running successfully but Restoration in Secondary server is not happening


All the 3 jobs are running successfully but Restoration in Secondary server is not happening

Author
Message
Chowdary's
Chowdary's
SSC Veteran
SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)

Group: General Forum Members
Points: 242 Visits: 566
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...
Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19872 Visits: 17242
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" ;-)
Chowdary's
Chowdary's
SSC Veteran
SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)

Group: General Forum Members
Points: 242 Visits: 566
Hi Sir,
I Have Checked all the Steps there was no failures in that
PFA..

Please help me out....

Regards
Chowdary...
Attachments
restorejob.jpg (11 views, 292.00 KB)
Beatrix Kiddo
Beatrix Kiddo
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2700 Visits: 4391
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.
Chowdary's
Chowdary's
SSC Veteran
SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)

Group: General Forum Members
Points: 242 Visits: 566
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...
Beatrix Kiddo
Beatrix Kiddo
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2700 Visits: 4391
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'.
Chowdary's
Chowdary's
SSC Veteran
SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)

Group: General Forum Members
Points: 242 Visits: 566
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...
Beatrix Kiddo
Beatrix Kiddo
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2700 Visits: 4391
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?
Beatrix Kiddo
Beatrix Kiddo
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2700 Visits: 4391
Sorry; I even switched browsers, and the duplicates keep happening.)
Chowdary's
Chowdary's
SSC Veteran
SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)SSC Veteran (242 reputation)

Group: General Forum Members
Points: 242 Visits: 566
Hi Sir.

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

Regards...

Regards
Chowdary...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search