Data Backup and Recovery

Get MSSQL DB & Log file path from SnapCenter CLI?

CSCOTTENO
1,265 Views

Hi,

 

Is it at all possible to get the physical file path for a DB's .mdf and .ldf files via SnapCenter Powershell?  It seems SC *knows* the path since it shows it when one does a "migrate" on a DB.  The migrate wizard shows the current physical file paths for the .mdf and .ldf and asks the user to input new paths.  Either SC has that info in its DB already or does a quick query of the instance to get that info.  How can that info be pulled from SC's brain via Powershell?

 

Physical path as:

E:\mssql\mssql.mdf

F:\mssql\mssql.ldf

 

0 REPLIES 0
Public