April 26, 2009 at 8:50 am
How do i get list of database names and their sizes from 2 different servers.
April 26, 2009 at 9:52 am
Hello,
Does sp_databases return the data that you need?
If so it can be executed via a Linked Server e.g.
Exec MyServer1.master.dbo.sp_databases
Exec MyServer2.master.dbo.sp_databases
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
April 27, 2009 at 1:13 pm
not sure if you want size of the database files or the backup size, but this thread provides a query (see post by sergiy) that returns both for all databases in an instance
]http://www.sqlservercentral.com/Forums/Topic704671-8-1.aspx?Update=1
If this is a query you will run frequently use a linked server else for an ad-hoc query you can use openrowset
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply