GilaMonster (6/9/2011)

---

What do you gain by that? Other than ensuring that if the full backup is damaged you have NO recovery path.

Please read through this - Managing Transaction Logs[/url]

muthukkumaran Kaliyamoorthy (6/8/2011)

---

forsqlserver (6/8/2011)

---

u can Check it

Can you give me the reference.Where you got it.

If i truncate the log file AFTER doing a full backup , how can i lose data?

The full backup as all the data.

It's like this:

muthukkumaran Kaliyamoorthy (6/9/2011)

---

In bulk logged PTR is not possible.

river1 (6/9/2011)

---

"In bulk logged PTR is not possible"

What is PTR?

No data can be lost, that's why i need do change the recovery model to full.

What i ask is :

In simple recovery model, log don't grow so much and when i make a backup the total size of the file backup is small.

forsqlserver (6/8/2011)

---

u can Check it

Yes, but you must log ship to a different database name

forsqlserver (6/7/2011)

---

Dear Muthu,

Thanks but DBCC shrink is deprecated.