login's default db

Posted on 2014-08-15
Medium Priority
Last Modified: 2014-08-20
when the login's default db is not 'master', is that an issue?
Question by:25112
  • 2
  • 2

Author Comment

ID: 40263499
2 scenarios:

a)login has permissions to only one user db 'TEXR'. so should the def db be TEXR only or MASTER is preferred, or does not matter?

b)when you restore TEXR with yesterday's backup with a REPLACE option, will that give error because login will 'miss' its default database for a few minutes?
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 40263534
The default db should the  db to use
The only issue I got was when user tried to login while that db was offline, it won't fallback to master db.

Author Comment

ID: 40263660
so you would only choose TEXR as the default database? other than when user logs in, is there an issue during a RESTORE with REPLACE (for the default DB for logins)?
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 2000 total points
ID: 40264755

Obviously, during the restore the db is down.
If you haveanother db to fallback to, you could alter all the relevant logins to have that other db as default, and change back after the restore...

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question