This post is more than 5 years old
202 Posts
0
3932
NMM SQL server filestream backup
Dear Experts!
Our customer want to backup SQL server with NW8.2.3 and NMM8.2.3.
However we got the following error during the backup:
>SQL Server FILESTREAM support is not enabled for this instance.
>Database db1 using FILESTREAM functionality cannot be backed up.
Question:
- How can we set up with NMM backup?
- It is possible with NMM?
- It is the problem on the SQL server side or NMM side?
Thanks in advance.
BR:
Pal Szabo
CarlosRojas
1.7K Posts
1
January 20th, 2017 01:00
Hi Pal,
This is documented, you need to enable FILESTREAM:
The FILESTREAM database must be configured with a higher Filestream Access Level.
To enable the appropriate access:
- Open the 'SQL Server Configuration Manager'.
- Highlight/Open the 'SQL Server Services'.
- Right-click the 'SQL Server' service for the appropriate instance and click Properties.
- Enable the following options:
1. Enable FILESTREAM for Transact-SQL access (Enabled when FILESTREAMS are enabled).
2. Enable FILESTREAM for file I/O streaming access
3. Allow remote client to have streaming access to FILESTREAM data
- Open the 'Microsoft SQL Server Management Studio'.
- Right-click the SQL instance via the Object Explorer and go to Properties.
- Click on the Advanced page.
- In the 'Filestream' section, change the 'Filestream Access Level' to Full access enabled.
Thank you,
Carlos
paulo3
202 Posts
0
January 20th, 2017 01:00
Dear Carlos!
Thanks for the superquick response!
Please tell me which config docs mentions this setup, i searched through the NMM8.2 admin guide and
and SQL VDI guide, but i dont find this settings!
BR:
Pal
paulo3
202 Posts
0
January 20th, 2017 01:00
Thanks for all!
BR: Pal
ble1
14.3K Posts
1
January 20th, 2017 01:00
https://support.emc.com/kb/421121