none
sqlserver backup settings RRS feed

  • Question

  • hello I draw backups of my databases,
    if something happens to restore the last backup and nothing happens ..

    but what about the security section, server object, replication, and management settings, you can take backup of that ...

    and also the sqlserver agent settings ...

    Sunday, September 29, 2013 12:20 AM

Answers

  • Hi neonash,

    The security settings, and a lot of the management settings are stored in the master database.  http://technet.microsoft.com/en-us/library/ms190679.aspx

    The agent settings are stored in the msdb database.

    It is recommended to backup both of these databases for replication technologies.


    ________________________________________________________________________________

    Please click the Mark as answer button if I answered your question, and vote as helpful if this reply helps you. Thank you!

    Sunday, September 29, 2013 2:35 AM
  • Hi Neonash,

    The role of system databases for the functioning of SQL Server cannot be underestimated due to the significant amount of information which is stored within these databases.It’s a best practice to create daily backups of all the system databases.

    • master - this holds information about logins and also information about all other databases
    • msdb - this stores jobs, operators, alerts, backup and restore history, database mail information ,etc...
    • model - this is used as a model for all new databases.  If you want certain objects to be in all new databases this is where you configure this information.
    • tempdb - this database is created each time SQL Server starts so there is not a need to back this up.

    There are also few other system databases based on the features you have used.

    Refer for better understanding

    If you have proper backups of all the system and user databases then you can restore and recover the SQL Server system in the event of a system failure

    Thanks

    Please click the Mark as answer button and vote as helpful if this reply solves your problem




    Sunday, September 29, 2013 6:01 AM

All replies

  • Hi neonash,

    The security settings, and a lot of the management settings are stored in the master database.  http://technet.microsoft.com/en-us/library/ms190679.aspx

    The agent settings are stored in the msdb database.

    It is recommended to backup both of these databases for replication technologies.


    ________________________________________________________________________________

    Please click the Mark as answer button if I answered your question, and vote as helpful if this reply helps you. Thank you!

    Sunday, September 29, 2013 2:35 AM
  • Hello,

    In short you should backup all user and system databases to recover completely from any failure.

    Exception lies with tempdb you cannot perform backup and restore operation on tempdb.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Sunday, September 29, 2013 5:39 AM
  • Hi Neonash,

    The role of system databases for the functioning of SQL Server cannot be underestimated due to the significant amount of information which is stored within these databases.It’s a best practice to create daily backups of all the system databases.

    • master - this holds information about logins and also information about all other databases
    • msdb - this stores jobs, operators, alerts, backup and restore history, database mail information ,etc...
    • model - this is used as a model for all new databases.  If you want certain objects to be in all new databases this is where you configure this information.
    • tempdb - this database is created each time SQL Server starts so there is not a need to back this up.

    There are also few other system databases based on the features you have used.

    Refer for better understanding

    If you have proper backups of all the system and user databases then you can restore and recover the SQL Server system in the event of a system failure

    Thanks

    Please click the Mark as answer button and vote as helpful if this reply solves your problem




    Sunday, September 29, 2013 6:01 AM