I was able to bring down the count to 12. Now I am keeping the log file size to approx 1GB and used space is .05% . Thanks for your...

David Jackson (9/15/2011)[/b]

---

My guess is your log is set to auto-grow in 10% chunks, and it started at 1 Mb. So the first time it grew it went to...

Lowell (8/26/2011)

---

Guras (8/26/2011)

---

But does 'DB_DenyDataWriter' prevent them from being able to create and drop objects in that database? In other words if I can give the role read and insert...

But does 'DB_DenyDataWriter' prevent them from being able to create and drop objects in that database? In other words if I can give the role read and insert and update...

Thank you all for the replies, they all have been a great help. After reading all the information I have decided to SHRINK the t-log file (and I uderstand that...

We found out one of the databases just had full back up and no t-log back up. We started the t-log back up now but the original t-log is still...

I ran the DBCC openTran(mydb)

but there is no open transactions.

How do I to locate queries that consume a large amount of log space?

Thanks for your help.

SQLRNNR (8/18/2011)

---

Precisely.

What...

Yes 10% growth.

yes the db is set to full recovery and I am backing up the transaction log. But Why do you ask that question ..in other words what triggered you to...

It will grow by the amount you set it to grow.

May be the following post will help you understand it. I had similar question and friends here have helped me...

I like you answer ! 😀

My boss is saying if the space used is 10GB then the database size should have been 10GB, why it's 100GB? I am trying to explain that remining 90GB is...

No, I don't have any database tasks scheduled betwen these two times.

Manual data entry as well as automated data updates.