Skip to main content
Question

Is setting MS/SQL to single-user while FME runs a good idea ?

  • December 11, 2018
  • 1 reply
  • 9 views
lifalin2016
Supporter
Forum|alt.badge.img+40

Hi.

I'm wondering whether it's safe to set the MS/SQL database that FME works with to single-user while processing it ?

I.e., sets the DB to "single-user" before pushing data into it, and to "multi-user" after FME's done.

Are there any serious caveats that I should be aware of ?

Cheers.

-- Cheers, Lars I.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

M
Forum|alt.badge.img+2
  • markatsafe
  • December 11, 2018

I don't think we can really answer that as it depends on your organisations use of SQL Server and the protocols you have for maintenance. SQL Server database single user mode is designed for database maintenance - so would generally be restricted to black out periods for database maintenance. If you switch to single use mode then all other users are logged off the database and no longer have access until the database reverts to multi-user mode.

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.