I ran and it worked. I will be keeping this db in simple because it is development server.

What do you mean and take a full backup to restart the log...

How can I check if some of my records were updated, do I need to wait until it finish?

Log Size (MB)Log Space Used (%)

21595.39.264401

Thia is what I have, is this ok?

This what it showing:

SPIDStatusLoginHostNameBlkByDBNameCommandCPUTimeDiskIOLastBatchProgramNameSPID

55 sleeping my user...

Yes, this is update running from query analyzer.Do you have other suggestions how I can run qyicker?How can I check if my logs are not full?Thank you

for log space I have this 772.92973.181445

Thank you, I did that and what is the next step?

how can I shrink?

I have a space and I just ran full backup on my db. My backup failed because of the space issue and that was fixed. What code for shrinking should...

Database NameLog Size (MB)Log Space Used (%)Status

db1809.2422 91.06001 ...

This is a maintance plan: How much space do I need for transaction back?

Error message I get for transaction job:

Date10/15/2009 5:00:00 PM

LogJob History (SQL Backup transaction log job created 11/25/2008 3:24:53 PM)

Step ID1

Serverttttt

Job NameSQL Backup transaction log job created 11/25/2008 3:24:53 PM

Step Nameexecute...

This is development server. Transaction job supposte to be every hour but it is been failing for ever. This is full db

Thank you

Thank you