definitely, oh well...

there are too many chitters lately.

it would be great to remove this article not to create confusions.

thank you for the article, but it is really misleading and not providing much useful information.

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, 4 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,...

Both good solutions - thanks!