Skip to Content
avatar image
Former Member

List all databases

Experts!!

How can we get all databases running on any machine?

nikhil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 04, 2008 at 01:02 PM

    Hi,

    If you are on SQL Server you can use

    sp_helpdb

    or

    select name from sys.databases

    Regards

    Ayyapparaj

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      thanks for the reply ayyapparaj

      plz give some hints on the following scenario.

      I have two MaxDB instance on one machine. I want a dynpro to do backup/restore of any database instance. On the way, I thought of it to be a generic one so that if we specify any host name in the landscape, it would list all the databases(MaxDB) and we can choose among which one backed up/restored.

      That is need to list all databases on a particular machine. And please help me on Backup & Restore operations.

      thanks in anticipation

      nikhil