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

log shipping tables query Expand / Collapse
Author
Message
Posted Wednesday, September 5, 2012 2:06 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, September 25, 2014 4:29 AM
Points: 119, Visits: 451
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.

Post #1354372
Posted Wednesday, September 5, 2012 3:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:15 AM
Points: 6,640, Visits: 14,224
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"
Post #1354416
Posted Wednesday, September 5, 2012 6:30 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, September 25, 2014 4:29 AM
Points: 119, Visits: 451
thanks Perry ill take a look.

Post #1354482
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse