Solved!
Go to SolutionNMM 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 Rookie
•
1693 Posts
2799
1
Posted 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