hpradhan08
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\Dat
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or other version http://www.mssqltips.com/sqlservertip/1878/how-to-detach-and-attach-a-sql-server-filestream-enabled-database/
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\Dat a\FS_FILES TREAM'. 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\Dat a\ReportGe nerator_Da ta_01.MDF' ,
MOVE 'ReportGenerator_log' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\TLo gs\ReportG enerator_l og.LDF',
MOVE 'ReportGenerator_Data_02' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat a\ReportGe nerator_Da ta_02.NDF' ,
MOVE 'ReportGenerator_Data_03' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat a\ReportGe nerator_Da ta_03.NDF' ,
MOVE 'ReportGenerator_Data_04' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat a\ReportGe nerator_Da ta_04.NDF' ,
MOVE 'ReportGenerator_Index_01' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat a\ReportGe nerator_In dex_01.NDF ',
MOVE 'ReportGenerator_Index_02' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat a\ReportGe nerator_In dex_02.NDF ',
MOVE 'ReportGenerator_Index_03' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat a\ReportGe nerator_In dex_03.NDF ',
MOVE 'ReportGenerator_Index_04' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat a\ReportGe nerator_In dex_04.NDF ',
MOVE 'FS_FileStream_Files_01' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat a\FS_FileS tream_File s_01.NDF',
MOVE 'FS_FILESTREAM' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat a\FS_FILES TREAM'
what am I doing wrong here?
Getting following error:
Msg 3156, Level 16, State 6, Line 1
File 'FS_FILESTREAM' cannot be restored to 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat
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.
WITH
MOVE 'ReportGenerator_Data_01' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat
MOVE 'ReportGenerator_log' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\TLo
MOVE 'ReportGenerator_Data_02' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat
MOVE 'ReportGenerator_Data_03' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat
MOVE 'ReportGenerator_Data_04' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat
MOVE 'ReportGenerator_Index_01'
MOVE 'ReportGenerator_Index_02'
MOVE 'ReportGenerator_Index_03'
MOVE 'ReportGenerator_Index_04'
MOVE 'FS_FileStream_Files_01' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat
MOVE 'FS_FILESTREAM' TO 'E:\Microsoft SQL Server\MSSQL10.TESTDB4\Dat
what am I doing wrong here?
ASKER
Hi there,
Any suggestions please?
Any suggestions please?
Copied the filestream before the restore?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.