I have revised everything for the backup. Here is what i did.

For my own database:

1) Create a job schedule daily every 5 mins to backup Transaction log

2) Create a job...

kesmond (6/21/2011)

---

kesmond (6/21/2011)

---

muthukkumaran Kaliyamoorthy (6/21/2011)

---

kesmond (6/21/2011)

---

hmmm... how come now when i restore the transaction logs file, my database is gone? only have model db transaction logs and other db transaction...

kesmond (6/21/2011)

---

muthukkumaran Kaliyamoorthy (6/21/2011)

---

kesmond (6/21/2011)

---

hmmm... how come now when i restore the transaction logs file, my database is gone? only have model db transaction logs and other db transaction logs?...

muthukkumaran Kaliyamoorthy (6/21/2011)

---

I am rather new to sql so in terms of backup, would need your advice.

So i would do a restore from the full backup for Monday (with the...

muthukkumaran Kaliyamoorthy (6/21/2011)

---

kesmond (6/21/2011)

---

hmmm... how come now when i restore the transaction logs file, my database is gone? only have model db transaction logs and other db transaction logs? anybody...

muthukkumaran Kaliyamoorthy (6/21/2011)

---

I need some suggestions of a backup plan that has backups for FULL, INCREMENTAL and LOG backups, which factors in the relationship of the 3 backups.

SQL server doesn't...

hmmm... how come now when i restore the transaction logs file, my database is gone? only have model db transaction logs and other db transaction logs? anybody know why? what...

Hi, i have a queries, i have do a testing (sample) to set the transaction logs backup to occur every 5 minutes. But i have check that how come the...

Warwick rudd (6/20/2011)

---

As I said previously, to determine a backup strategy suitable for your situation, you need to know an understand your RPO & RTO. Ie if there is a...

muthukkumaran Kaliyamoorthy (6/20/2011)

---

kesmond (6/20/2011)

---

i gone thru the link that u have provided. but just have doubt over the transaction logs restore, as what i have painted on the scenario, we...

Warwick rudd (6/20/2011)

---

How did you come to the decision that you need a full backup taken on a Monday , with differential backups taken on every other day , with...

i gone thru the link that u have provided. but just have doubt over the transaction logs restore, as what i have painted on the scenario, we have to restore...

thanks for the prompt reply. But lets say example, i do a full backup on monday and a differential backup daily and transaction log daily for every 5 mins.

If...