The system DBs default to simple recovery mode on install so you don't need log backups for them. A full backup once a week should suffice.

It may involve re-installing the service pack. Check this out.

http://www.tek-tips.com/viewthread.cfm?qid=1127815&page=1

Our infrastructure team is separate from the application side, in a sense. They're responsible for procuring/repairing hardware and all other network needs, getting everything ready for the applications part of...

just.jelena (10/6/2008)

---

Hi

I have similar problem, keep getting messages

The statement has been terminated.

Msg 9002, Level 17, State 4, Line 1

The transaction log for database 'dbname' is full...

After running:

BACKUP...

The script, as Steve stated, is on this site at:

http://www.sqlservercentral.com/scripts/Index+Management/31475/

FYI - Each service pack is cumulative, so if you...

Hmmm....BOL and DBCC ShowCONTIG yields this:

E. Use DBCC SHOWCONTIG and DBCC INDEXDEFRAG to defragment the indexes in a database

Seems to be what Jeff is/was pointing to...

KDASQL (9/25/2008)

---

Schedule your full backup and then your tran log backups but when netapp will do a full backup of your db it will reset the check point on tran...

Thanks Chad. Many methods to the same result. The biggest item, and I cannot stress this enough, is to test your D/R scenario. Be absolutely certain that if you need...

Chad Carter (9/25/2008)

---

One issue with it is that your Differential backups will NOT be tied to your FULL backup from Backup Exec. Differential backups are changes since the last...

You can do a DBCC Shrinkfile but I would caution against doing this with any regularity (leads to physical disk fragmentation). MSSQL manages things appropriately - IMO. What are the...

The real question is - what do your business needs dictate (the old "it depends" answer)? Full backups and diffs provide protection but the logs and point-in-time restores will prove...

I always reserve myself!!! 😎 Table space is different in MS SQL than with some other DB engines. Setup the amount of space for the DB to allow for sufficent...

Thanks Jeff and David - I did a brief look-over and these appear to do what I need, with some tweaking of course. I'll post my final solution but, again,...

By default, msdb is not really using the log as it's set to simple recovery mode (truncates on checkpoint) so growth should be relatively small if at all. TempDb is...