This is what I thought. However, the Listening Port box is greyed out and I cannot select a different Port.

Any thoughts on how to overcome this?

A change of folder permissions AND a server reboot has resolved the issue.

Now error "Error loading from XML" "occues when CPackage::LoadFROMXML fails"

Having the same issue. Did you find a resolution?

Colin

OK Have used the SSIS, in NON mirroring mode. The login appears on the secondary server as a server login, with red arrow pointing downwards. But it does not appear...

One last thought!

Have you encountered issues with the .ldf file growing very large? A normal full Back Up has the effect of clearing out the .ldf and we will not...

I now have a much better understanding of the system and have managed some successful testing.

Many thanks for your help and support, greatly appreciated.

Colin

I put the same file path in both boxes, expecting the .trn file to appear in both directories at the same time.

This was not always the case. The Log Shipping...

Thanks very much.

Just one more query, for the moment.

When setting up LS there were 2 boxes called "Network Path to Back Up Folder" and "Destination folder for copied files". The...

Thanks.

What are the implications (for restore) in using the Copy_Only Back Up method?

Have tried the StandBy mode, but found that subsequent Log restores failed. Perhaps more testing?

I think that I finally solved this issue last night. Here is what I did, for other lost souls who encounter the same problem.

The Config file should NOT be created...

All,

Have resolved the issue by moving away frrom a mapped drive and using full file path \\ServerName\Director\AnotherDirectory\etc

Thanks

Colin

I have seen a number of articles recently on moving away from cursors and fully understand the performance benefits in doing so.

That said, I use cursors as I need to...

I believe that is what I have.

Each Task is speparate having its own SELECT clause and own connection manager to each server. The only connection between the tasks is that...

Thanks, however values are already set to false.

THANK YOU!

I changed the query to the formatbelow and enabled OPENROWSET under Surface Area Configuration. It has turned into quite a good day. 🙂

select objectGUID,

cn,

displayName,

SUBSTRING(userPrincipalName, 1, CHARINDEX('@', userPrincipalName)-1),

sAMAccountname,

givenname,

sn,

distinguishedName,

SUBSTRING(mail, 1,...