Post reply

db size

  • March 1, 2011 at 2:15 am

    #231948

    Hi,

    I wanna remote query script(means that query will be executing on multiple servers) which will give database name and database size for all databases..

    So that i can pull the data from multiple servers using that script.

    any suggesions will be greatly appreciated.

    Thanks

    Rekha

  • March 1, 2011 at 2:22 am

    #1292761

    I suggest you to start using Powershell.

    __________________________
    Allzu viel ist ungesund...

  • March 1, 2011 at 2:28 am

    #1292763

    But at this time i wanna t-sql script

  • March 1, 2011 at 4:58 am

    #1292822

    You can take help of linked server.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • March 1, 2011 at 5:40 am

    #1292829

    Hi Bhuvnesh,

    Thaks for reply

    yes i have to create an linked server for pull the data from multilple servers .i too thought like that .let me try once

    Thanks

    rekha

  • July 21, 2011 at 1:39 am

    #1356177

    Hi Rekha

    you can try with linked servers it's possible .

  • July 22, 2011 at 1:00 am

    #1356874

    have a look at a central management server,

    under registered servers --> database engine --> central management servers

    add in your central server, then register any child servers under the central server

    then you can execute a query against the central server which will execute against all the registered servers in one t-sql statement

  • July 22, 2011 at 1:17 am

    #1356877

    anthony.green (7/22/2011)

    have a look at a central management server,

    under registered servers --> database engine --> central management servers

    add in your central server, then register any child servers under the central server

    then you can execute a query against the central server which will execute against all the registered servers in one t-sql statement

    not available in Sql 2005 but its a sql 2008 feature. and only can be used in same domain

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • July 22, 2011 at 1:24 am

    #1356880

    not available in Sql 2005 but its a sql 2008 feature. and only can be used in same domain

    sorry my mistake, I went into the forums via the daily subscription, where as I usually go in via the web, so appologies.

    if you have a development 2008 server you can use this as the CMS and register 2005 servers that way

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply