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:

REMOVE FILE MyDatabase_Files;  

Thanks for any helps.

1 Answer 1


As the message suggests, you need to backup the transaction log in order to move on to the next step. You can do this inside SSMS with a couple of clicks or, if you prefer writing SQL, you can do this:

BACKUP LOG MyDatabase  
   TO MyDatabase_TXN_log1;  

Once this is completed the requisite ALTER DATABASE statements can be run before restarting the SQL Server instance 👍🏻

  • Thanks, But when I wanna get backup It raise this error: you should enable filestream on this instance While filestream is already enable. May 8, 2021 at 7:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.