Results 1 to 3 of 3

Thread: QUESTION FOR DBA

  1. #1
    LEENA AHMED Guest

    QUESTION FOR DBA


    How do you work, directly from the server or there are other ways to perform the administration??

    Thanks.

  2. #2
    Parasuraman Guest

    QUESTION FOR DBA (reply)

    Hi Leena,
    It depends on the situtation. You can administer the SQL server even from a remote machine.
    You can do this by connecting to the SQL Server which u want to adminster by giving the IP of the server in the SQL registration wizard.

    Hope this helps


    ------------
    LEENA AHMED at 9/8/01 2:42:12 PM


    How do you work, directly from the server or there are other ways to perform the administration??

    Thanks.


  3. #3
    Greg Guest

    QUESTION FOR DBA (reply)

    Leena,

    You have a number of options.

    1. Manage the server locally (at the server itself) using Enterprise Manager and/or Query Analyzer.

    2. Manage remotely from a workstation. To do this install (at least) the management tools (do custom installation of SQL Server & pick the bits you need) onto a workstation. At the very least these should include Enterprise Manager (EM), Query Analyzer (QA), Profiler and of course Books On Line. After installation, for each instance of SQL Server you want to manage, go Start | Programs | SQL Server | Client Network Utility and add a new connection. Then when you open EM right-click the server group and register your new SQL Server. To access this same serverfor the first time from QA, to the right of the "SQL Server: text box on the logon screen, click the ellipsis (...) and select your server from the list.

    3. Locally or remorely using ISQL or OSQL (a command line utility)

    4. Remotely(usually) using a third party tool such as Embarcadero's excellent DB Artisan.

    Hope this helps,

    Regards,

    . . Greg


    ------------
    Parasuraman at 9/9/01 12:06:52 PM

    Hi Leena,
    It depends on the situtation. You can administer the SQL server even from a remote machine.
    You can do this by connecting to the SQL Server which u want to adminster by giving the IP of the server in the SQL registration wizard.

    Hope this helps


    ------------
    LEENA AHMED at 9/8/01 2:42:12 PM


    How do you work, directly from the server or there are other ways to perform the administration??

    Thanks.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •