Post reply

Tables in master database

  • November 20, 2018 at 3:59 pm

    #380885

    Hi,

    So much learning here!!. Thanks in advance for answering my questions.

    I have 2 tables in master databases and I found out it is a BAD practice to have any tables in MSDB.
    1. How can I move them to user DB's?
     2.What actions I can take to remedy the problem since tables in MSDB might be unable to recover. Please explain and advise. 

    Thank you!

  • November 20, 2018 at 4:01 pm

    #2014156

    sizal0234 - Tuesday, November 20, 2018 3:59 PM

    Hi,

    So much learning here!!. Thanks in advance for answering my questions.

    I have 2 tables in master databases and I found out it is a BAD practice to have any tables in MSDB.
    1. How can I move them to user DB's?
     2.What actions I can take to remedy the problem since tables in MSDB might be unable to recover. Please explain and advise. 

    Thank you!

    1 - create new table. copy data. drop old table
    2 - do not grant anyone more access than what they really need - e.g. no sysadmin for anyone other than DBA's and even that through a controlled login

  • November 25, 2018 at 9:41 pm

    #2014466

    Great. Thank you for your advice. It helps!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply