You don't need the same room on the SAN.

If I have 100GB mdf and 60GB log on the dev machine, and I can shrink that to 80GB mdf, 10GB log,...

I didn't think this was the dev machine, but the production machine, moving a database that is processed to production.

SAN space in the US is around US$6k/TB from what I've...

How much of the data changes?

Is it better, perhaps, to build an ETL process to move the data instead of the full backup/restore?

I'd second Perry's note, and be concerned about moving from development to production.

If this is production moving to development, and you are low on space, there isn't a good way...

Jim Sleeman-388184 (7/15/2011)

---

Editorial is a bit dated. Since 2008 a large number of good IT people have been out of work for longer then a year. I was nearly one...

bopeavy (7/15/2011)

---

...

Laws aren't necessarily about stopping behavior, but they can exist to provide recourse when someone does make a mistake.

We've proven nicely that many companies don't want to take responsibility for...

I think there are places where DRI isn't needed, but not a lot. Most of the time it pays to enforce the FK relationships, or the constraints because they ensure...

WayneS (7/15/2011)

---

Lynn Pettis (7/15/2011)

---

Chad Crawford (7/15/2011)

---

Craig Farrell (7/14/2011)

---

Hey guys, does anyone know of boot camp training session(s) for SQL Server for practical skills (not certifications). I'm talking real...

GilaMonster (7/14/2011)

---

Steve Jones - SSC Editor (7/14/2011)

---

Probably is a lot more than 1kb. There's a lot of stuff that comes down from every single forum, along with a bunch of...

Probably is a lot more than 1kb. There's a lot of stuff that comes down from every single forum, along with a bunch of JS. I'd have to play around...

Devices don't matter. Is there something that your grooming jobs are doing? There's no reason for the backup to fail unless you are doing some switching of the recovery model.

Backups...

sturner (7/1/2011)

---

Freddie-304292 (7/1/2011)

---

Personally I would turn down any company that expected me to work weekends before they were even paying me. Some of us have lives, you know ;-)...

I would argue that DRI is important when you have bad data.

Packages ought to be designed to work with DRI, and if there are source problems, move error rows to...

I'd add Gail, but the...