Answer / suman

we have two types of backups that is inconsist backup and
consistent backup
online backup is inconsistent backup
offline backup is consistent backuup
1.when the database is up on running at that time we have to
take the online backup it means hot backup
2.when the database is shutdown stage at that time we have
to take the offline backup it means cold backup this is the diff

Answer / kittu_chintu2005

online backup: 1) inconsistent backup 2) database must be in archive log mode 3) database should be in upon running

offline backup: 1) consistent backup 2)database may be or may not be in archive log mode 3)database should in shut down state

Answer / mogal

as said above every thing is same but one more point. i.e
" in a hot backup it have fractured blocks and where as in
cold backup there is no fractured blocks"

What is dcl? : sql server DBA

0 Answers  

---

what is asm?

0 Answers   Oracle,

---

What is transparent data encryption? : sql server DBA

0 Answers  

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

how can you implement fine-grained auditing?

0 Answers   Oracle,

---

How to start SQL Server in minimal configuration mode?

1 Answers  

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

Name a tablespace automatically created when you create a database.

5 Answers  

---

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

---