Content rating: Beginner/review material. The most common database restore I do is the WITH MOVE format. I get DB backups from friends, book or presenter sites, and restore them on my box to play with. The RESTORE syntax WITH MOVE, from BOL, is: RESTORE DATABASE TestDB FROM DISK = 'C:\AdventureWorks.bak' WITH MOVE 'AdventureWorks_Data' TO 'C:\testdb.mdf', MOVE 'AdventureWorks_Log' […]
Author: Jen McCown
Contest Winner
Last night, with all the pomp, circumstance, and formailty due its gravity, we held the drawing for our first EVAR web contest. And the winner is…. Todd Holmes! Thank you all for playing, and we'll have more giveaways in the weeks & months to come. -Jen McCown, http://www.MidnightDBA.com
Impromptu Panel on Agile Development
In the course of our interviews at the PASS Summit 2009 this month, we managed to snag four top-level SQL authors and educators at once, in the same room. (Actually, in the same 8'x8' space, but who's counting.) In Part 2 of our series "Buck, Paul, Joe, and Louis", we have an absolutely wonderful talk […]