Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
samsekar
Constraint Violating Yak Guru
437 Posts |
 Posted - 2003-03-28 : 06:36:03
|
| What are Hot and Cold Backups??Where can i get information about this in Detail?Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-28 : 07:57:15
|
| Think you mean standby system.Hot standby is a system which is kept up to date with the live system and can be switched to at any time. All updates to the live system must also be made to the standby.Warm standby is one which is slightly out of date. Updates to the live system are made to the standby in batches so there is a delay in bringing up the standby. Switching to the standby may also lose transactions.Cold standby isn't usually used as a term but usually means that a lot of work has to be done e.g. building a sytem, restoring backups, ...You could use hot and cold backup to mean whether or not the system has to be taken down to back it up.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-28 : 08:34:50
|
What are effective ways for having Hot Standby Systems The first i got in my mind is failover Clustering. Any other ways..EDIT: Replication.Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey.Edited by - samsekar on 03/28/2003 08:37:29 |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-28 : 11:28:04
|
| Any load balanced systems?Depends on what you mean by hot standby.Any read only system can have a hot standby which is just copy of the database and the switch done automatically.Some busineses are happy to lose some data so you could restore differentials (or just overnight) and still call it hot.Mirror'd disks?A lot of companies spend a lot of time looking into transaction log backups and things like that when they are really quite happy to restore from the previous night.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-28 : 12:41:56
|
| Samsekar, are you asking about hot and cold backups or standby systems?Tara |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-03-29 : 09:05:55
|
| A hot back up is the backup which is taken when the data base is live still online while users are connected to the database and an cold backup is thebackup which is taken when the database is not online,it is not live and no users are connected to the database.Expect the UnExpected |
|
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-31 : 00:54:57
|
First I thank you All.As nr said,quote:
Hot standby is a system which is kept up to date with the live system and can be switched to at any time. All updates to the live system must also be made to the standby.
I need to know the effective ways of acheiving this. Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-04-01 : 09:43:52
|
| Depending on the interval you use to backup your transaction logs you can use log shipping. It's more of a luke warm to almost hot solution. If you truely want a hot stand by that is always up to date and will automatically take over in case of a failure, I think you'll need to look into something like an active/passive cluster.Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
Hot/Cold Backup