can you also provide the output of

DBCC loginfo ('TEEST')

or

sys.dm_db_log_info ( database_id )

replace database_id with database_id value from sys.databases

if it returns more than 300 rows just state how many

on those db's that case issues I would start by looking to see how many VLF's they have. and if too many get the source (production DB) fixed in the...

and.... how many VLFs - higher number does delay restore.

and... if restoring from a lower SQL version system objects will also be upgraded - this adds to restore time.

if you bother to look at the results of the index definition you will discover why its null.

and get used to use alias on the tables - makes your life...

if you do your clustered index as you...

you really need to read the manuals for MySQL - datediff in Mysql is totally different of that for SQL Server hence the error you get.

in mysql you would need...

all the SP's on...

Cyberark if used...

there is documentation for it - https://docs.cyberark.com/Product-Doc/OnlineHelp/AAM-CP/Latest/en/Content/CP%20and%20ASCP/Net-Application-Password-SDK.htm?tocpath=Developer%7CCredential%20Provider%7CApplication%20Password%20SDK%7C.NET%20Application%20Password%20SDK%7C_____0

as in powershell you can use any .net dll's its just a question of setting up a script to do it.

I may be able...

Hello @bobrooney.81 the solution to your problem is quite easy: Start thinking by your self. Then switch to https://ola.hallengren.com. There you find every necessary information about your problem.

But hey:...

I believe your only solution for this is to setup a SQL Agent job that executes the SSIS package (with a defined proxy) and introduce a SP to allow your...

what will that package do?

• Access file system (on another server or locally to the server - if remote it won't work)
• access remote database (if so it will require...

what is that proc doing?

and what are you trying to accomplish (end target)

as it resides on SSISDB I would suspect you are trying to start a package execution - and...

@databases = 'USER_DATABASES,db1,db2', -- USER_DATABASES will do all user db's including db1 and db2 - if your intention is to backup only db1 and db2 then your strings should be

@databases...

as you have been advised on other similar queries you need to implement a storage of these metrics onto a table at a point in time - and then build...