February 11, 2010 at 2:27 pm
Hi,
We just started using new software that uses a SQL db. They store their tables in the master. I had never seen that before so I am asking if that is OK and if not, why not?
February 12, 2010 at 2:07 am
No. Nothing should be created by users in the Master database. That's what user databases are for.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 12, 2010 at 2:27 am
Master database contains all the system-level information for a SQL Server system.
February 12, 2010 at 6:51 am
thats very bad practice. Are you sure you did not miss out a 'use database' when you did the install?
Master database is not intended for user tables.
Master database always operates in simple recovery mode so you will never be able to recover your user data to a point in time.
If you ever do want to restore your data you will have to do a master database restore, which is more complex.
If you upgrade SQL you risk the app stopping functioning or even the upgrade failing (and any pre-upgrade backups are practically useless)
you may be giving users of the app a higher level of access to SQL then is sensible.
---------------------------------------------------------------------
February 12, 2010 at 6:55 am
This is what I thought--just needed the amunition to go to the boss and get this corrected. Thank you
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply