Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Where do settings gets saved in SQL server?

Answered Where do settings gets saved in SQL server?

  • Wednesday, August 01, 2012 2:12 PM
     
     
    Sign In to Vote
    0
    In sql server where does all configuration settings of database are stored? ( i know that master database includes instance-wide metadata such as logon accounts) But where does other settings gets saved in sql server?(for example settings related to replication done in sql server by user etc)
     

All Replies

  • Wednesday, August 01, 2012 2:40 PM
     
     Answered
    Sign In to Vote
    0

    Tables for replication saves at 4 places msdb, distribution, publication db , subcription db.

    More details :- http://msdn.microsoft.com/en-us/library/ms179855.aspx

    Server level configuration, agent history saved in master & msdb.

    Different features use diffrent tables in diffrent DBs.

    Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!


     
  • Saturday, August 18, 2012 5:15 AM
     
     
    Sign In to Vote
    1
    I got information like "The MSDB database contains data needed to perform SQL Server Agent activities: backups, notifications, alerts, replication, log shipping and more". Here what backup means?does it normal backup we do in sql server or is it related to any scheduled backup or jobs? Does msdb stores system configuration like username and password of sql log in? 
     
  • Tuesday, August 21, 2012 5:49 PM
     
     
    Sign In to Vote
    0

    Database backup via SSMS GUI, T-SQL on Query windows, SQL AGent schdule Jobs or by any third party tools, deatils of time & type of backup will store in MSDB databse.

    Login related information stores in master database.

    Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!