NetApp Community Update
This site will enter Read Only mode on July 23 as we prepare to move to a new platform.
You will still be able to view content, but posting and replying will be temporarily disabled.
To learn more, please review the information in this blog post.

Data Protection

Get MSSQL DB & Log file path from SnapCenter CLI?

CSCOTTENO
2,098 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