Sample Header Ad - 728x90

change file table file stream data folder faces error The container can not be dropped

0 votes
1 answer
260 views
I want to change file database file stream folder from Drive D to Drive F. I successfully transferred data to new folder but when I want to Remove old file stream folder I face this error: **"The container can not be dropped because changes exist that require a log backup. Take a log backup and then retry the ALTER DATABASE operation."** When I want to get transaction log, It encounter this error: you should enable filestream on this instance, while filestream is enabled. This my code: ALTER DATABASE MyDatabase REMOVE FILE MyDatabase_Files; GO Thanks for any helps.
Asked by Mohammad Ali Barati (11 rep)
May 5, 2021, 12:32 PM
Last activity: May 21, 2025, 06:06 PM