briansalentine (11/19/2009)

---

I found that a department was running reports for a very large date range, so, this brought our normally 7GB- 10GB database up quite a bit. We basically...

This topic is also for those of us serving in the "Jack-of-All-DBA-Jobs" role. @=)

Did you try the solution I posted above?

And if this sort of thing will happen more than once, consider storing your .mdf and .ldf names in a table on a database that doesn't tend to get moved....

Sorry, GSquared. I have an anti-ditto (of a sort) to your list.

RE: Indexing. Yes, index. But don't OVER index.

Pet Peeve = developers add an index to an existing table just...

Ah, I misunderstood your post.

Good luck with the battle.

If you're the network tech, why are you responsible for the log shipping? I would think that it (and testing backup software) would be the responsibility of the DBA team.

Unless...

First look up CREATE LOGIN, CREATE USER and sp_addrolemember in BOL (Books Online). This will give you all the syntax you need.

Dynamic SQL is the act of putting SQL...

The problems with any backup tool is that if it breaks or you lose your license, you have all these backups you may not be able to restore if the...

One by one? Ah, you need to be more creative. @=)

If you can only "fix" certain users, try putting the specific logins in a table on a DBA only database...

Thanks, Gail. I'm patient and any new links you have would be greatly appreciated. FYI, looking at your very first link above, I found my answer.

The transaction log has...

I'm sorry, but I'm still not clear on what you want to accomplish. Could you be more detailed?

Not quite sure what you're asking. Do you mean you want to create a trigger that looks at the input before anything happens so you can verify there's no SQL...

You're going to have to write up a script.

The way I do it is to have my restores created in jobs. After the restore step, I have a script...

mahesh.vsp (10/31/2009)

---

Assuming we are having the 300 GB of database which would take 3 hrs/more to take the full backup.

In such cases, do we need to go for only...