More importantly are they differing versions of the Windows OS

What OS are the current nodes?

What OS are the new nodes to be?

The following when executed against the LS primary databases instance will return configuration info

exec sp_help_log_shipping_primary_database 'primaryLSdb'

The following when executed against the LS secondary databases instance will return configuration info

exec sp_help_log_shipping_secondary_database...

ipgsql (1/24/2013)

---

Hi,

Looking for some opinions/links. If a SQL server (OLTP) is restricted to a single box with max 8 drives, would four RAID1 arrays (OS,TEMPDB,LOGS,DATA) be the way to go?

Or...

Posting your issue once only and in the correct forum will yield you better results!!

All replies here http://www.sqlservercentral.com/Forums/Topic1411479-1549-1.aspx

The AO nodes must be part of...

Have you tried removing the LS monitor as detailed above?

No! Really, you think?

Is this a VMWare ESX farm or some other hypervisor?

Which version of the hypervisor are you using?

Are the virtual machines disks all virtual disk files or are you using Raw...

+1

I would use the sys.database_files catalog and compare that against sys.master_files

I'll keep this brief as there are already a wealth of articles and white papers on...

If you have availability groups set up and working why on earth do you want to use Log Shipping?

This details how to migrate from Log Shipping to AO groups, this...

and all that's easier than a quick check in the dbo.sysjobhistory table??

NJDave (1/23/2013)

---

Hello

I am installing SQL Server 2008 R2 Enterprise on a 2 node cluster and reached the instance configuration in the wizard. There is a field to complete labeled "SQL...

selectj.name

, convert(smalldatetime, convert(varchar(20), max(jh.run_date)))

, CASE jh.run_status

WHEN 0 THEN 'Failed'

WHEN 1 THEN 'Success'

WHEN 2 THEN 'Retry'

WHEN 3 THEN 'Cancelled'

END AS Run_Status

from msdb.dbo.sysjobs j

inner join msdb.dbo.sysjobhistory jh on

j.job_id = jh.job_id

where j.name =...