SQL 2000 has a version column. You can use that if you store the previous value, which would require some job that grabs this daily and looks for changes.

You could do that. Give you some abstraction.

If it's acceptable, you could let someone edit/add information in Access linked to the table.

If locks are an issue, you could have them use Access in staging table and then...

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

lshanahan (4/23/2013)

---

Maybe it's little old me, but I was surprised at the very least at the statement: "Having knowledge about the way your business works, the way they use data,...

Raju Lalvani (4/23/2013)

---

The first step would be to master the current development platform you are working on before spending time on other skills. With each development platform gettiing bloated with...

When the...

I would agree with Gail on the shrink.

As for the size, there is no right size. If you are getting 2GB daily, 2GB might be fine for the size. I...

Your service account may not have rights to that path. Not all accounts will. You'll have to determine if that's the case.

If the db is recovering, you will have to...

You don't need to map a drive. The service account for SQL Server logs into Windows. It can't see your drive mappings when you've logged in with RDP.

Instead, run the...

You don't need to take anything offline to run a backup. If you take the database offline, you can't run a backup in SSMS.

As far as the mapped drives, the...

If you're loading 1-2 GB a day in the log, I'd shrink the log to 5GB. Space is relatively cheap, and this gives you pad.

You don't need a 140GB log,...

Those are not the...

Jeffrey Williams 3188 (4/22/2013)

---

GilaMonster (4/21/2013)

---

Let's see... what happens when we have a 6-hour full backup duration and a 15 minute data loss SLA and log backups don't run during that...

My thoughts:

If you are updating this once and day, and it's your database, important, but not affecting others, here's what I'd do.

Change the database to simple mode. With updates once...