tosscrosby (5/22/2009)

---

Personally, I never backup the data folder. Unless you shutdown the SQL server, the files are in use. As stated by David, there are some applications that allow you...

David (5/22/2009)

---

You know, I was never a fan of open file SQL agents, until in my last job the RAID array died (twice!) and the parity was corrupted (or so...

is there any benefit to setting up a dev/qa cluster? we have clustered SQL servers but our dev and qa are on standalone sql servers and we have never had...

not that i'll ever run SQL under VS 2005 in production, but isn't one of the benefits of virtualization that you don't need to set up MS clusters? the servers...

i like the term "cloud computing" better than all the other buzzwords they came up for it over the last 10 years

but nothing really changes. you still have to set...

we have one DB that takes almost 40 minutes to recover after a reboot. it's around 600GB and the schema isn't exactly by the book

when you install clustered instances it still installs files to the local c drives of each node. my guess is the clustered installs overwrote that and this is why you...

you have a cluster with a nonclustered instance on one node and 3 instances on the cluster?

never understood the point of doing it

if you do it over the network there is network traffic overhead and you're probably using tempdb a lot more to cache the data

check with the SAN vendor since they all their own best practices

we have a lot of databases on an EMC DMX-3 and they mostly 3+1 RAID5's on the backend and...

Perry Whittle (4/7/2009)

---

thanks, thats something i didnt know. I knew you could get ESX3.5i (got a copy myself) but i didnt know they gave away ESX 3.5, presumably you dont...

ESX 3.5...

homebrew01 (4/3/2009)

---

We just tried a full backup with Backup Exec to compare and that took 7 hours. A vast improvement ! With Redgate I had set compression to '0', but...

did you say Pentium 3's? cell phones have more power these days and nehalem CPU based servers are cheap

just create multiple databases