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


log shipping tables query


log shipping tables query

Author
Message
n00bDBA
n00bDBA
SSChasing Mays
SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)

Group: General Forum Members
Points: 630 Visits: 467
i have two test log shipping servers set up. both going to different secondaries but using the same backup location and monitoring server..

Both are working, i get no errors and can look on the secondaries and see up to date info for the last backups.

So why in msdb tables. does one have NULLs for restored_file and date

SELECT secondary_database,
last_restored_file,
last_restored_date
FROM msdb.dbo.log_shipping_secondary_databases



NULLS in

SELECT  primary_database ,
last_copied_file ,
last_copied_date ,
last_copied_date_utc ,
last_restored_file ,
last_restored_date ,
last_restored_date_utc ,
last_restored_latency
FROM msdb.dbo.log_shipping_monitor_secondary




for everything except last_restored_date and last_restored_date_utc

But the other has all those details filled in.

Hope someone can help.


// EDIT

I decided to remove the log shipping that was having NULLS (I dont have NULLS anymore.. Any ideas what i did to cause that???)

Also can you only have one log shipping DB monitored by a instance? I give each db monitor job a different name but Its just replaced the old monitoring job for the other db.. (didnt notice before) I cant see any reference in BOL.
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54141 Visits: 17684
nulls would indicate that although the backup and copy are running no logs are being restored, there can be many different reasons why this happens.

Carefully check the job step history for the restore job

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

"Ya can't make an omelette without breaking just a few eggs" ;-)
n00bDBA
n00bDBA
SSChasing Mays
SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)SSChasing Mays (630 reputation)

Group: General Forum Members
Points: 630 Visits: 467
thanks Perry ill take a look.
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