Thanks for that.

Based off those links you provided I've managed to create the attached (see screenshots).

I managed to get the Insert working just fine, but couldn't manage to get an...

Sorry for the late response Jefferey.

Thanks for that, learnt a lot in this thread. Thanks again.

Thanks Jeffrey, good to know that's the correct way of doings things.

In terms of the database files themselves now, what's the best settings here given I'm now doing transaction log...

Got it running transaction log backups every 15 minutes, differential every 3 hours, and full backups at 9pm.

One problem though that I had earlier is that the SQL log file...

Thanks heaps 🙂

Jeffrey Williams (3/23/2009)

---

JamesNZ (3/23/2009)[/bVery good point. Just to check my thinking, if I'm taking a full backup every night at 9pm, I can delete all differential and transaction log backups...

Jeffrey Williams (3/23/2009)

---

That really depends upon your business, but what would happen if your boss came to you and said that you need to restore the system back to yesterday...

Jeffrey Williams (3/23/2009)

---

If disk-space isn't as big an issue, and 1 hour data-loss is acceptable, is it worth simply just running a differential backup every hour and leaving it at...

GilaMonster (3/23/2009)

---

JamesNZ (3/22/2009)

---

Mark it as reusable or clean the space completely? A log file for a db didn't shrink down to 0KB, and stayed at 3.2GB, any idea on why...

Thanks for the great response Jeffrey 🙂

The transaction log backup will run with no problems. There use to be a problem in SQL Server 2000 where they would block, but...

Following on from my first post, See attached screen-print.

I've got the attached maintenance plan with just that task attached to job running every 15 mins.

The problem is it doesn't...

Solved this myself, turns out it was a simple issue around the worksheet being renamed by someone :ermm:

I've just created a lookup table and done it that way 🙂

I'm needing to expand the query further now, and was wondering if you could help? Here are the details:

The...

Sorry about that, it did produce the correct result, when I added where Status ='Open' 🙂

How would you suggest I change the 1, 2, 3, 4, 5..... to 1 wks...

Thanks for responding mate, however the result should be:

Age Total

Up to 1wk old 60

1wk to 2wks old ...