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.