Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Server Size

Author  Topic 

ratheeshknair
Posting Yak Master

129 Posts

Posted - 2008-07-17 : 06:22:02
Hi Experts,
Is there any way to know the size of server(remote server) as a whole,i mean the total size of all the databases.

RKNAIR

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-17 : 08:14:00
quote:
Originally posted by ratheeshknair

Hi Experts,
Is there any way to know the size of server(remote server) as a whole,i mean the total size of all the databases.

RKNAIR



sp_databases will give you all databases name and size. I donno about total size .
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-17 : 23:51:17
Add them up to get total size.
Go to Top of Page
   

- Advertisement -