I'm also not a DBA, though lately I've been doing some DBA things in addition to my normal work.

However, like Alvin, I normally like to work with the DBA to...

Brandie Tarvin (8/27/2010)

---

ACK! We've been invaded! There's one of those non-DBA...

Others have already mentioned there's no easy way to do this and you have a lot of work in front of you. I'd like to add that you should take...

Alvin Ramard (8/26/2010)

---

WayneS (8/26/2010)

---

Stefan Krzywicki (8/26/2010)

---

On a side note, why busses? Why aren't people in these theoreticals brought up in too many meetings ever hit by taxis, trucks, private cars,...

At that point, I'd tell them flat out...

CirquedeSQLeil (8/26/2010)

---

Stefan Krzywicki (8/26/2010)

---

CirquedeSQLeil (8/26/2010)

---

So here is my question of the day

How do you convince somebody that archive data should not be changed?

Data integrity didn't work

Point in time visibility did...

CirquedeSQLeil (8/26/2010)

---

So here is my question of the day

How do you convince somebody that archive data should not be changed?

Data integrity didn't work

Point in time visibility did not work

Reporting consistency...

djdhere (8/25/2010)

---

Hello All,

I need some help with creation of DB for a Bank ERP software

(Its having near about 300 branches )

Main Bank -> Their branches.

My queries are that -How we...

Brandie Tarvin (8/25/2010)

---

Alvin Ramard (8/25/2010)

---

OP was complaining about PK violation while uploading text file using SSIS.

Someone replied with:

How do you get a PK violation?

Are you inserting the PK values yourself?...

GilaMonster (8/23/2010)

---

If you're taking file/filegroup backups, when you restore you'll need to restore Primary, restore the other files/filegroups, then restore log backups that cover the interval at least between the...

GilaMonster (8/23/2010)

---

If you're taking file/filegroup backups, when you restore you'll need to restore Primary, restore the other files/filegroups, then restore log backups that cover the interval at least between the...

GilaMonster (8/23/2010)

---

Just be aware that if you go Simple, you won't be able to do piecemeal restores (restoring filegroups from backups taken at different times), unless those filegroups are read-only....

Steve Jones - Editor (8/23/2010)

---

If you set to simple, then Gail is correct. But if you have it in full recovery for any reason, you need those log backups. Not...

GilaMonster (8/23/2010)

---

Unless there's something that mandates full recovery (mirroring/log shipping) I'd just...

GilaMonster (8/23/2010)

---

If it's only updated once a day (so no need to worry about point-in-time restore) I wouldn't bother with log backups at all.

Weekly full, daily diff right after...