Hot backup In SQL server RRS feed

  • Question

  • hi all,

    what is the Hot backup in sql server  and how it will take?
    please explain me.

    • Moved by Todd McDermid Thursday, October 1, 2009 3:21 AM Off Topic (From:SQL Server Integration Services)
    Thursday, October 1, 2009 2:19 AM


  • Hi

    A hot backup is when you take a backup when the SQL Server is still runing.
    For example with the command BACKUP DATABASE (BOL Description)

    A cold backup is when you stop the SQL Server, and the database is no longer avalibale to the users, and then you backup the MDF, and the LDF files with som backup software.

    Jens Nilsson MCTS - SQL Server 2008 Imp. and Main.
    Thursday, October 1, 2009 5:19 AM