I am curious if there's a way to move the secure store db to another db using powershell.

  • move it to a different server


  • What u want, move secure store db to different server or create new db for secure store service?
    – Waqas Sarwar MVP
    Commented Nov 8, 2016 at 16:08
  • move it to a different server if possible...if not we'll need to create a new db for secure store.
    – Vader
    Commented Nov 8, 2016 at 16:17

1 Answer 1


There is no supported commands to move the Secure Store DB from one Server to others. You have to do it manually. But if you want, you can create a new database for Secure Store Database.

To create New Database

  • You can use the Set-SPSecureStoreServiceApplication command.To create a new db for the Secure Store Service.
  • Another approach is to delete the current Secure Store Service and then recreate it using powershell.Follow this for creation new SS application or this

Or you can do it as MSFT recomend.

  • Stop the service application
  • Detach the database from SQL Server
  • Move database files to a new location
  • Attach the database to a new instance of SQL Server
  • Point the service application to a moved database

here is the MSFT tech net Article.

Your Answer

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

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