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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy