I think it is a 2008 database. As soon as you restore it, the structure converts. If it's set to the compat mode, I'm not sure what else you could...

My apologies. I'm not sure if this was submitted with the wrong boxes marked, or I made a mistake, but we've corrected it.

Points have been awarded back and thanks for...

I like the hand waving step 😉

What about using a reporting database at company B with views to the log shipped db, and then enabling some level of cross database...

If you're looking for the ABS() in a repeating way, is there some ordering column? Rows in SQL have no order by default, so you can't find a pattern without...

Dentist

Ugh

GSquared (7/19/2011)

---

Freddie-304292 (7/19/2011)

---

I think it's a bit unfair to say that people out of work for a year are bad DBAs. They may be great DBAs, but bad at...

I mostly agree with Mr. Klopcic, and you ought to look to train constantly, or retrain if you are struggling to find work. Or move. The unemployment situation varies widely...

I saw a Discovery Channel special on the destruction of old Yankee Stadium while flying across the Atlantic. Very cool how they pulled it down, given the proximity to the...

congrats, Mr Moden!

And perhaps why this occurred: http://voiceofthedba.wordpress.com/2011/07/18/sql-server-backup-inadvertent-striping/

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...