here is the updated script:

-- Get database file information for each database

IF OBJECT_ID('TempDB..#holdforeachdb') IS NOT NULL

DROP TABLE #holdforeachdb;

create table #holdforeachdb

( [databasename] [nvarchar](128) collate sql_latin1_general_cp1_ci_as not null,

[int] not null,

[name] [nvarchar](128)...

• This reply was modified 4 years, 3 months ago by  1974lg.

Hi Robby, you are completely right, it messed up over there somehow. good catch. updating it. thank you!

SET NOCOUNT ON

SELECT @@VERSION [VERSION],

CONVERT(VARCHAR(100), SERVERPROPERTY('Servername')) Servername ,

CONVERT(VARCHAR(100), SERVERPROPERTY('ProductVersion')),

CONVERT(VARCHAR(100), SERVERPROPERTY('ProductLevel')) Product_SP_Level,

CONVERT(VARCHAR(100), SERVERPROPERTY('ResourceLastUpdateDateTime'))ResourceLastUpdate,

CONVERT(VARCHAR(100), SERVERPROPERTY('ResourceVersion'))ResourceVersion,

ISNULL(CONVERT(VARCHAR(100), CASE

...

you can use register servers and run one of the proposed queries or you can create list of servers and run PS as below:

$Servername=("SQLC-EST-IN-N5\INTERNAL","SQL1", "SQL2","SQL..n")

foreach ($Server in $Servername)

{

$output += (invoke-sqlcmd...

you can also restore from full backup with norecovery and then only transfer the latest trn backups (alternative to log shipping), restore them.

of course depends how big the trn backups,...