locked
Hot backup In SQL server RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    hi all,

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


    Thanks,
    Ramaprasad.
    • 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

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    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.

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