GilaMonster (9/8/2010)

---

yessen (9/8/2010)

---

Well my sysadmin uses backup-exec software to save the mdf and ldf files every day, which is not the full backup of the database. If lets say everything...

Well my sysadmin...

Something that I thought about:

My database ships transaction log once a day and that keeps it from growing too large, which is great!

However, I set it to delete all the...

Sorry to bother again,

I am shipping my transaction logs every day at 10pm. The size of the log file was constantly around 20gb and the transaction log backups everyday were...

Grant Fritchey (6/28/2010)

---

There a number[/url] of articles[/url] right here on SSC that can help you out. You just need to use the Search window over there in the upper right...

Once a week? Sure about that? That means that the log will get big enough to hold a full week of transactions. The usual frequency for log backups is somewhere...

You guys are amazing!

I just switched to FULL logging.

Backed up database fully.

Shrinked log file using DBCC SHRINKFILE.

checked VLFs, now only 4.

Set auto-growth to 5gb.

backed up log file, it...

I switched to simple logging like 5 days ago to prevent files growing too much because my boss was happy if we could not restore at particular point of time....

GilaMonster (6/25/2010)

---

yessen (6/25/2010)

---

Once I have a small log file and few VLFs. My databases should not take much time recovering (i.e checking for consistency) if I need to restart SQL...

Based on what I have read:

Currently it is 300gb log file.

If I backup log files it becomes empty ( less than 1gb something like that) and these 300gb will...

I have read it. It makes sense I have more than 30 000 VLFs because prior DBA set autogrowth size...

Grant Fritchey (6/25/2010)

---

yessen (6/24/2010)

---

GilaMonster (6/23/2010)

---

You're confusing concepts. Log chain has to do with whether you can do point in time restores (restore a database to any time) using RESTORE DATABASE...

GilaMonster (6/23/2010)

---

You're confusing concepts. Log chain has to do with whether you can do point in time restores (restore a database to any time) using RESTORE DATABASE and RESTORE LOG.

Recovery...

GilaMonster (6/22/2010)

---

yessen (6/22/2010)

---

Is there a good way to maintain .ldf size at certain size? I tried to set the MAXSIZE = 10gb but when it reached that size my database...

GilaMonster (6/22/2010)

---

full database backup or differential database backup. Check books online if you want more details

I guess the point in time restoration...