Thanks for the links (esp. the first one).

I made more progress and also found this script here to be immensely useful: https://dba.stackexchange.com/questions/201776/grant-user-from-my-database-to-execute-xp-cmdshell

On the server itself in control panel --> Local...

Hi Grant, thanks for your feedback. I think I'm going to move away from Maintenace Plans and use the relevant sql code as I will have more control over the...

Sincere thanks to all those who contributed. I have better understanding of the issues involved and the coverage required. Much appreciated, J.

Hi everyone,

Thank you all for your comments & practices you suggestions, many of which we are already doing. To answer you queries:

We are doing the weekly full back directly to...

Hi Sue,
   
   Thanks for the suggestion. I t was already added but I tried again and moved it around etc for blank and standard templates and tested a...

Hi Jeff (no, the other one)
    Thanks for the suggestions. I tried a few different templates and a few other variations and while handy, I still cannot get...

Hi Jeff, yes the "TextData" column is displaying. I have played with it's location relative to the other ie first, second last position but when I click on the rtow...

Lets use a database restore as an example:

RESTORE DATABASE TestRestore

FROM DISK = 'SomeCorrectPath'

WITH RECOVERY,

MOVE 'WrongDataName' TO 'D:\SQL2014\Data\TEMPCOPY.mdf',

MOVE 'WrongLogFile' TO 'E:\SQL2014\Logs\TEMPCOPY.ldf'

The above will throw an error as the logical file names...

Thanks for the advice. Forgive me but how do you create a different SQL instance lets call it "TestInstance"

I think so - Above the words :"Tail-Log backup" it says :"Leave the database ready to use by rolling back uncommitted transactions. Additional transaction logs cannot be restored"

However I feel...

Well it defaults to "Restore with Recovery" - is this correct?

No I'm afraid not. I will keep digging - thanks for your assist this far.

J.

Yes, of course - your right joeroshan. Good spot I should have seen it myself. Well, that's a dead end then. It does not really explain why sometimes the error...

Awesome Drew. This works. Thank you both. J.

I do recall seeing message "x rows effected" but it may have been syntax error on my part. I *may* have done something like:

update someTable

set='newValue'

where someField='oldValue'

As I say - this...