1434 udp is only required if not connecting to the named instance directly and usually if the instance is using the non standard port 1433

are all the datafiles in separate filegroups?

Great blog Kendal (you have way too much time on your hands 😀 )

very informative

filter out tempdb objects too

Mike Levan (2/18/2009)

---

Jack

If you want notifications you can do the DDL triggers or you could do a job that queries the default trace on a regular basis which sends you...

Jack

did you mean to specify column I.StartTime twice?

works for me, double check what you copied and pasted

Magy

sounds like the best advice is check what machine backup software you currently use. Check if there is an open file agent, if so trawl through your recent tapes looking...

dude

substitute

exec sp_ExecuteSql @sqlstr

for

Print @sqlstr

and post the output

at a guess your login credentials dont allow you to install the software, group\local policy in force maybe?

the most complex part of the system is getting the cluster and its resouces in place, the rest is plain sailing

ALZDBA (2/18/2009)

---

We use this sequence:

1) restore the db to SQL2005

2) DBCC for DATA_PURITY

3) switch to dblevel 90 (if possible)

4) rebuild all indexes (individually)

5) dbcc updateusage with count_rows

6) sp_updatestats

7) synchronize users

8)...

run it on...

select serverproperty('edition')

Jeff Moden (2/15/2009)

---

Heh... that's one man's opinion. Anything that won't even allow for more than a 30 character object name certainly isn't the most flexible of the two. ...