Data Backup and Recovery

SMSQL - Reports folder

BrendonHiggins
2,594 Views

Is there a way to configure the default "Report Directory Settings" in SMSQL, so that it does not default to "C:\Program Files\NetApp\SnapManager for SQL Server\Report".  We have an MSCS SQL server and like to keep the report folder on a LUN so that it is visible to the active cluster node, with the history of older jobs after the active node has been switched.  But it some how keeps on reverting to the c:\ drive.

Thanks

Brendon

1 ACCEPTED SOLUTION

radek_kubka
2,594 Views

Hi Bren,

I don't know the actual answer to your question, but I believe you can use a mount point:

1) Move all the content of "C:\Program Files\NetApp\SnapManager for SQL Server\Report" to somewhere else

2) Once the folder is empty, use it as a mount point for your LUN

3) Move the legacy data back into the folder

Should work IMHO.

Regards,
Radek

View solution in original post

1 REPLY 1

radek_kubka
2,595 Views

Hi Bren,

I don't know the actual answer to your question, but I believe you can use a mount point:

1) Move all the content of "C:\Program Files\NetApp\SnapManager for SQL Server\Report" to somewhere else

2) Once the folder is empty, use it as a mount point for your LUN

3) Move the legacy data back into the folder

Should work IMHO.

Regards,
Radek

Public