April 1, 2008 at 8:12 am
Hello everyone!
can explain somebody what does it mean " HOT BACKUP " it was as subquestion of
What is the backup in general and what is HOT Backup!? -
anyone help me how to explain that!
thnx!
Dugi
April 1, 2008 at 9:06 am
In my experience, a "hot" backup is one made while the database is available for use as opposed to the database being closed and unavailable ("cold" backup).
I learned this while working with an older version of Oracle. "Hot" backups are the norm with SQL Server.
Greg
April 1, 2008 at 9:18 am
A "hot backup" usually means taking a backup without shutting down the server. When you run a backup in SQL Server, it's a hot backup. A "warm backup" typically means running a backup when there's no one connected to the server (or no activity). A cold backup is when you backup files and the SQL server service is stopped.
I typically have heard these terms with other RDBMSes, not SQL Server. SQL has no need for a cold backup.
April 2, 2008 at 2:19 am
April 2, 2008 at 6:17 am
I think HOT backup means backup taken on working DB and have no debuggs and which is fresh
ThX
Suresh Babu V
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply