SQLCrazyCertified (4/5/2013)

---

SQLRNNR (4/4/2013)

---

SQLCrazyCertified (4/4/2013)

---

mp5387 (4/4/2013)

---

I am intermediate in database admin. Please give me your solution for this issue.

Size of my db is growing about 5M every 2 weeks. Now its size is 118G. my db is in full recovery mode, and I do not have log backup.

Is this a good solution?

1- Perform a full backup

2- execute checkpoint

3-Perform full Backup

4- Perform transactional log backup

5- shrink log file type

6- schedule transactional log backup

Also, can I do these processes during users are connected ?

I would say, do full backup weekly, daily differential and hourly log backups based on the RTO provided.

If your database is in full recovery model, then definitely, you need to do log backup to truncate the logs.

SueTons.

An RTO was not provided. And your suggestion has more to do with RPO and not RTO. Though neither has been specified so they are both unknowns.

Thanks for the correction, however, I thought RPO(Recovery Point Objective) and RTO(Recovery Time Objective) are basically same? Please let me know.

SueTons.