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
Last activity: May 21, 2025, 06:06 PM