List all databases

[nikhil_bose]

Experts!!

How can we get all databases running on any machine?

nikhil

[Former Member]

Hi,

If you are on SQL Server you can use

sp_helpdb

or

select name from sys.databases

Regards

Ayyapparaj

[nikhil_bose]

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