Link to home
Start Free TrialLog in
Avatar of hpradhan08
hpradhan08Flag for United States of America

asked on

How to move FileStream enable DB from one Server to another


Hi there,
I'm trying to move the FileStream enabled DB from one server to another and got the following error:

Msg 3156, Level 16, State 6, Line 1
File 'FS_FILESTREAM' cannot be restored to 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Data\FS_FILESTREAM'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Could you please help?

SOLUTION
Avatar of jogos
jogos
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hpradhan08

ASKER

I saw those articles and didn't help me. That's because I'm restoring from primary to secondary server... Could you please help?

Getting following error:

Msg 3156, Level 16, State 6, Line 1
File 'FS_FILESTREAM' cannot be restored to 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Data\FS_FILESTREAM'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Here are the scripts:

USE [master]
GO
RESTORE DATABASE ReportGenerator
FROM DISK = N'F:\Temp\ReportGenerator.bak'
WITH
MOVE 'ReportGenerator_Data_01' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Data\ReportGenerator_Data_01.MDF',                                                                                                                                                                                                    
MOVE 'ReportGenerator_log' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\TLogs\ReportGenerator_log.LDF',
MOVE 'ReportGenerator_Data_02' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Data\ReportGenerator_Data_02.NDF',
MOVE 'ReportGenerator_Data_03' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Data\ReportGenerator_Data_03.NDF',
MOVE 'ReportGenerator_Data_04' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Data\ReportGenerator_Data_04.NDF',
MOVE 'ReportGenerator_Index_01' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Data\ReportGenerator_Index_01.NDF',
MOVE 'ReportGenerator_Index_02' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Data\ReportGenerator_Index_02.NDF',
MOVE 'ReportGenerator_Index_03' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Data\ReportGenerator_Index_03.NDF',
MOVE 'ReportGenerator_Index_04' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Data\ReportGenerator_Index_04.NDF',
MOVE 'FS_FileStream_Files_01' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Data\FS_FileStream_Files_01.NDF',
MOVE 'FS_FILESTREAM' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Data\FS_FILESTREAM'

what am I doing wrong here?
Hi there,
Any suggestions please?
Copied the filestream before  the restore?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you.