I don't think a degree of any type is a prerequisite to being a successful DBA, but people in technical jobs tend to come that route, and of course nowadays...

what worries me about allowing automatic updates of SQL service packs is where's the backout? system DBs should be backed up first, and a copy of the resource database taken...

well certainly not delete then drop.

It looks to me that truncate from a large table and drop a large table are in effect handled in the same way, see

http://msdn.microsoft.com/en-us/library/ms177495(SQL.90).aspx

so going...

cmille19, thanks for the prompt reply, appreciate it.

sorry to bang on but I need to clarify some points. you are using SQL clusters yes? Because mine are standalone servers so...

cmille19 (7/20/2007)

---

That's correct at the DR site there is an identical server where all volumes are replicated at the disk level from one SAN to another SAN over two OC3...

Why? Because I have found (security) auditors require xp_cmdshell be disabled, and they also question any application user id with elevated privileges and may not allow it.

I find it most...

Jeff Moden (5/2/2009)

---

Enable xp_CmdShell, leave it enabled, and restrict all users...

as part of the same job enable xp_cmdshell just before the bcp and disable it again immediately afterwards

reduced elapsed time for backup, spread the i/o load.

that's about it

Louis Kapp (5/1/2009)

---

One would think so, but the last time I tried to do this without kickin them off it took nearly an hour and a half, compared to 15...

homebrew01 (5/1/2009)

---

george sibbald (5/1/2009)

---

remove the need to monitor the log space used from the procedure by setting up a performance alert in SQLAgent to backup the log when it reaches...

GSquared (5/1/2009)

---

I think I'd go with something at the beginning of the loop in the proc that checks the log and backs it up as needed.

That way, you don't have...

It would be the snapshot agent connecting to the publisher and taking out the locks rather than the distributor agent. That will run under the auspices of the sql server...

remove the need to monitor the log space used from the procedure by setting up a performance alert in SQLAgent to backup the log when it reaches a certain percentage...

first of all if its a DR box for a particular server insist on the same drive configuration and install SQL on it to exact same specifications as live box,...