Post reply

find out database name

  • May 27, 2011 at 7:18 am

    #238891

    How I can find out the name of the database which is in a server without starting the services of the database in that server and without running the studio management in that server? Is there any file containing the names of the database?

    thanks.

  • May 27, 2011 at 7:39 am

    #1330990

    physical file? no...you have to ask the SQL isntance what databases it currently has ...usually via a query, though...for example

    SELECT name from master.dbo.sysdatabases

    why don't you want to connect to discover the databases via a query?...or you could set something up to start dropping the list to a file for the future.

    you could read the event logs for each database being opened the last time the SQL service was started...that would be possible....but you'd have to parse the logs to get that data.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 27, 2011 at 8:28 am

    #1331025

    thanks for your reply, i´m the backup admin and db admin told me db can not be started because a kind of interference problem; we are in a migration.

    So , i searched for a file in c: looking for a kind of log where i could find the ddbb name but i didn´t find anything.

    thanks .

Viewing 3 posts - 1 through 3 (of 3 total)

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