February 27, 2018 at 6:08 am
Hi
I am log shipping SQL2012 databases over to a new sql2016 instance. We will be bringing all our client databases online at some point in the near future (the log shipping is just to make the move easier by simply doing a final Log ship backup, copy and restore when we are ready to upgrade to the sql2016 instance)
On the 2012 instance, we have a couple of database that use file stream.
The file group is named 'AW_DS_FS_GROUP_dbname'. The path is simply E:\Filestream.
On the 2012 instance I can these 'AW_DS_FS_GROUP_dbname' folders within the E:\Filestream location.
However on the secondary 2016 instance these folders have appeared within the 'D:\Logs', which is the location of the restoring transaction logs for the Log shipping setup.
How to I change this to D:\Filestream on the secondary when I cant access the databases properties because the databases are in a 'recovering' state.
Thanks
February 27, 2018 at 6:57 pm
Have you restored the initial full backup on the second server with MOVE option? https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql
MOVE 'FileStream' to 'D:\Filestream'
March 1, 2018 at 8:04 am
Evgeny Garaev - Tuesday, February 27, 2018 6:57 PMHave you restored the initial full backup on the second server with MOVE option? https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql
MOVE 'FileStream' to 'D:\Filestream'
March 1, 2018 at 8:28 am
PearlJammer1 - Thursday, March 1, 2018 8:04 AMHi
No I never used the MOVE option. Within the initialisation of Log shipping using the GUI there is not an option to do this as far as i know.
In the setup of Log shipping, when you connect to the Secondary server instance and select your secondary database, I used the option "Yes,generatre a full backup of the primary database and restore it into the secondary database(and create the secondary database if it does not exist).
The restore options on that initialization page allows you to change the locations. Check the Restore Options section in this documentation - that's the option you want to use to change the file locations:
Secondary Database Settings
Sue
March 1, 2018 at 8:57 am
Sue_H - Thursday, March 1, 2018 8:28 AMPearlJammer1 - Thursday, March 1, 2018 8:04 AMHi
No I never used the MOVE option. Within the initialisation of Log shipping using the GUI there is not an option to do this as far as i know.
In the setup of Log shipping, when you connect to the Secondary server instance and select your secondary database, I used the option "Yes,generatre a full backup of the primary database and restore it into the secondary database(and create the secondary database if it does not exist).The restore options on that initialization page allows you to change the locations. Check the Restore Options section in this documentation - that's the option you want to use to change the file locations:
Secondary Database SettingsSue
Yes but that is just for the data file and log file. Where can you specify the location of the 3rd file for the File Stream data?
March 1, 2018 at 10:16 am
PearlJammer1 - Thursday, March 1, 2018 8:57 AMSue_H - Thursday, March 1, 2018 8:28 AMPearlJammer1 - Thursday, March 1, 2018 8:04 AMHi
No I never used the MOVE option. Within the initialisation of Log shipping using the GUI there is not an option to do this as far as i know.
In the setup of Log shipping, when you connect to the Secondary server instance and select your secondary database, I used the option "Yes,generatre a full backup of the primary database and restore it into the secondary database(and create the secondary database if it does not exist).The restore options on that initialization page allows you to change the locations. Check the Restore Options section in this documentation - that's the option you want to use to change the file locations:
Secondary Database SettingsSue
Yes but that is just for the data file and log file. Where can you specify the location of the 3rd file for the File Stream data?
Then initialize it yourself. That is also an option. And you would do that using just the regular restore database t-sql with standby or read only.
Sue
March 2, 2018 at 3:15 am
Sue_H - Thursday, March 1, 2018 10:16 AMPearlJammer1 - Thursday, March 1, 2018 8:57 AMSue_H - Thursday, March 1, 2018 8:28 AMPearlJammer1 - Thursday, March 1, 2018 8:04 AMHi
No I never used the MOVE option. Within the initialisation of Log shipping using the GUI there is not an option to do this as far as i know.
In the setup of Log shipping, when you connect to the Secondary server instance and select your secondary database, I used the option "Yes,generatre a full backup of the primary database and restore it into the secondary database(and create the secondary database if it does not exist).The restore options on that initialization page allows you to change the locations. Check the Restore Options section in this documentation - that's the option you want to use to change the file locations:
Secondary Database SettingsSue
Yes but that is just for the data file and log file. Where can you specify the location of the 3rd file for the File Stream data?
Then initialize it yourself. That is also an option. And you would do that using just the regular restore database t-sql with standby or read only.
Sue
Ok - Thanks for your advice. I have done as you suggested. Like you say, its more of manual setup having to initialise the database yourself and point the File stream data to the required location but everything is now as it should be.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply