Data Backup and Recovery

Get MSSQL DB & Log file path from SnapCenter CLI?

CSCOTTENO

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
Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public