how big are the log backups? Any of about 30GB hence leading to the log file growth?

If you right click the database, select reports,standard reports,disk usage you can see if...

If the log file grows, it's because one of these

a) you don't have log backups

b) you have replication or mirroring that are preventing truncation

c) your load is increasing to the...

returns:

'NOTHING'

but log file last Monday was 21.3 G

log file this Monday was 33.1 G - after backing up log every hour and full backup every night.

Gotcha

Thanks George/Lynn!

Have a good day!

What's...

thanks for all your helps George.

One last question, in my Maint plan, I have the trn files set to expire after 3 days.

Does that delete the trn files? (freeing...

Thanks George..

I created the Maint plan for the log.

It did create the trn file the same size as the log, but it did not shrink the log. Is that...

It's

FULL

sorry George

name log_reuse_wait_desc

ULTIPRO_WSILOG_BACKUP

Thanks Lynn..

the results:

2013-05-15 12:14:17.000 2013-05-15 12:23:18.000

2013-05-15 19:17:23.000 2013-05-15 19:36:35.000

2013-05-16 15:15:36.000 2013-05-16 15:35:51.000

2013-05-17 19:19:32.000 2013-05-17 19:37:31.000

2013-05-20 19:18:11.000 2013-05-20 19:36:09.000

2013-05-21 10:12:09.000 2013-05-21 10:21:17.000

2013-05-21 19:19:15.000 2013-05-21 19:37:12.000

2013-05-22 19:17:05.000 2013-05-22 19:35:28.000

2013-05-23 19:18:45.000 2013-05-23 19:36:47.000

2013-05-24...

declare @dbname sysname

set @dbname = db_name()

print @dbname

select backup_start_date,backup_finish_date,

from msdb..backupset

where database_name = @dbname and type = 'D'

Msg 156, Level 15, State 1, Line 5

Incorrect syntax near the keyword 'from'.

This tells us you need to start running t-log backups at a minimum. You also need to get with your network people (or who ever works with your backup software)...

Lynn,

results:

LOG_BACKUP

Pretty sure it's because the Unitrends software is not working as it should. But I'm stuck with the UNitrends device to backup out servers.

So my thought was that I would...

Okay given my scenario...

should I run this first:

BACKUP LOG <database_name> WITH TRUNCATE_ONLY;

every night (scheduled), then do a full backup?

I'm concerned with space..

Thanks Sean! Worked great.

Yeah I know about the (no lock)...the vender has these all over the place..

crazy I know..

Thanks everybody for helping!