Guys,

thanks for all information but not everyone understands what I want to do (and script style is irrelevant in this issue):

I registered some servers in a folder in the CMS...

• This reply was modified 2 years, 5 months ago by  gkramer 23701.

Eirikur,

This is the select from the table on the source server:

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

#Retreiving the last written XML from the source-server

$SelectQuery = @"select logdate, runnum, servername, Report  from.[dbo].[XML_REPORT] where RunNum = (select Max(RunNum)...

Eirikur,

Thanks for the reply - I will provide the (basic) code used:

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

Table on the CMS server to collect info from different other servers:

CREATE TABLE [dbo].[XML_REPORT_ALL](

[Logdate] [datetime] NULL,

[RunNum] [int] NULL,

[ServerName] [varchar](400)...

• This reply was modified 2 years, 5 months ago by  gkramer 23701.

Ken,

Thanks for the reply.

I found the Azure Process Automation and created a runbook form one of the templates availabe (deleting files in a blob older the X days).

I modified the...

Thanks Ken,

you pushed me in the right direction !

The main issue it didn't work was the difference between an Azure FILE-SHARE and an Azure BLOB-STORAGE.

I was trying to backup to...

Andry,

Thanks for the quick reply.

You mentioned Powershel but all I had ever had to do I could manage with TSQL (often using XP_CMDSHELL to work on commandline, OPENROWSET/OPENQUERY and LINKEDSERVER).

PS...

Sue,

Thanks you - this pointed me into a direction I overlooked.... I will investigate and ask our AD-Networks specialist(s) to look into it.

Guus

Sue,
Thanks for pointing to theMS article.
I will make a VM-snapshot and upgrade to the given SP/CU (or to SP4).
Guus

Steve,
autogrowth is turned on with plenty of space to grow if needed.
Guus

Enterprise edition

Thom,

Execent suggesting (not to warp it up at the end but  CAST direct on the column to retrieve).
First test is positive !!!

Regarding the VARCHAR part ...

@TheSQLGuru

I located the failed logfile, but executing the restore, it stated this one was too young and the previous logfile stated it was too old - and there...

Gents,

after some more scripting I found out that if I place the "IF" outside the dynamic part it will work fine....

only now I do have a lot of extra lines...

FridayNightGiant,

thats not he issue - I deal wit version number in the SERVERTABLE (as mentioned).

Guus