we have 10 or more policies on netbackup for backing up SQL. i just added 4 more the other day. and there is never a need to hunt for tapes...

is it critical data? once in a while we have to rerun a snapshot in the day. we've upgraded our hardware in the last 2 years and have a dedicated...

windows 2000 is out of support. windows 2003 is going end of mainstream support in 2010

create views to access the data for each user

are you talking about the Windows quotas? i always found them useless

i have the same problem in a security database i admin. we dump event logs to it and every server monitored has at least one table. some reports have a...

which error are you getting?

sometimes shrinking won't work due to open connections so we have to restart SQL and shrink right away before another connection starts hitting it

thx

sent this up the chain and we might try it out

not exactly what you're looking for, but my favorite way to email result sets is via Reporting Services subscriptions. very easy to read on mobile phones as well

check out the Windows certs, Exchange, VMWare or Oracle

not the best study guide, but preplogic is having a sale with the SQL 2005 guide costing $1 or $5. it's a pdf which is annoying, but i read it...

ironically a month or two ago i got a ticket to create a table in a non-critical database and one of the columns was for Y/N but i think the...

Knight (9/11/2009)

---

This is what I use to list failed jobs

SELECT DISTINCT

CAST(CONVERT(datetime,CAST(run_date AS char(8)),101) AS char(11))AS 'Failure Date',

SUBSTRING(T2.name,1,40)AS 'Job Name',

T1.step_id AS 'Step_id',

T1.step_nameAS 'Step Name',

LEFT(T1.[message],500)AS 'Error Message'

FROM msdb..sysjobhistory T1

JOINmsdb..sysjobsT2

ON T1.job_id =...

great article i just found

in my case i can't use linked servers in all cases to monitor jobs so i'm going to change the code to use SSIS and maybe...