How to identify and get the sqlserver data files filepath

Question

I am afraid that i am unable to locate the absolute path of the SQL SERVER data files.

I have tried to so do by doing the following.

    foreach( Database db in srv.Databases)
     string filepath=db.PrimaryFilepath;
     string name=db.Name;
     abspth=filepath+"//"+name+".mdf";

Like this i have workaround.But is there is any alternative to get the absolute path.

But in case of logfiles it gives absolute path.......

Help me in this regard...

Thanks in Advance.

marc_s · Accepted Answer · 2009-06-18 05:33:59Z

2

The Database in SMO should contain a Filegroups collection which in turn contains a Files collection - you should find your file path's in there.

        foreach(FileGroup fg in db.FileGroups)
        {
            foreach(DataFile df in fg.Files)
            {
                Console.WriteLine("File path: {0}", df.FileName);
            }
        }

Marc

answered Jun 18, 2009 at 5:33

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to identify and get the sqlserver data files filepath

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related