Yes, I'm still banging my head against the wall on that one.

Cheers...

Hey Jeffrey,

I know what you were getting at - the jibes were all good natured in intent, no worries.

if you read my last post I found the cause of the...

Steve Jones - SSC Editor (1/24/2011)

---

The log can still grow if you have one large transaction. Without knowing what the process is, it's hard to tell, but log backups do...

Steve Jones - SSC Editor (1/24/2011)

---

If you are set to simple mode, transaction log backups do not work or matter. Each checkpoint (every few minutes) results in a clearing of...

As you wish...

Jeffrey Williams-493691 (1/22/2011)

I have a 1TB+ database that I can backup in...

the backups are stored on an external HD. An array would be better but simply isn't going to happen...unfortunately...

But Thank you and everyone else for all your answers and...

CirquedeSQLeil (1/20/2011)

---

Your full backup takes 8hrs and you only backup the transaction logs once a day? How many transactions a day are you running?

Do you need to be able...

Thanks again for all the replies.

I know it's not the best situation, but I don't have control over the database, I have to work within the limits that I'm...

Steve Jones - SSC Editor (1/20/2011)

---

1) Is that all I need to safeguard the database given that I only need to restore, if necessary, to the previous day or am...

I understand that transaction logs are a quick save - that's not my concern however. I'm told once a day is more than adequate for our needs.

Is...

"Let SQL Server do what it's good at..."

That is exactly the "rule of thumb" I was hoping to hear - Thanx Dave

Answer found - There was a trick to it and it can only be done if reporting services is post Sevice pack 1.

Normally hiding the variable makes it "read only"...

I'm continuing this post from a Half year ago - Mark if you've found the answer i hope to hear from you.

Likewise I'm using SQLServer 2000 reporting services and I...