SQL query split over two server

[Rdosramos]

Hi All,

I need to run the following script

 USE VaultStoreDatabase
SELECT AV.ArchiveName, vAP.ArchivedItems
FROM view_ArchivePoint vAP INNER JOIN
EnterpriseVaultDirectory.dbo.ArchiveView AV ON AV.VaultEntryId = vAP.ArchivePointId
ORDER BY ArchivedItems ASC

https://www.veritas.com/support/en_US/article.000017500

But the problem I am facing is that the directory database is located on another server. Can anyone suggest how I could write the script locally on the vaultstore database sql server and referencing the directory database on a remote server?

[GertjanA]

I cannot assist in writing it, but you need to use something called 'linked server'.

See - https://msdn.microsoft.com/en-us/library/ff772782(v=sql.110).aspx

You can then use something like :

USE VaultStoreDatabase
SELECT AV.ArchiveName, vAP.ArchivedItems
FROM view_ArchivePoint vAP INNER JOIN
SQLSERVER1.EnterpriseVaultDirectory.dbo.ArchiveView AV ON AV.VaultEntryId = vAP.ArchivePointId
ORDER BY ArchivedItems ASC