OK, so let me take another stab at this.

I know that the sources will be .csv files. Please tell me what I should ask the owner of the...

Thank you very much. It was a sanity check as well 🙂

Oh....Happy New Year!

Hi, I haven't received replies for this question. I am not sure if it is because I am not being clear enough about what I need, of if it...

I didn't take the 70-431.

My careful advice to you is to read the training kit by M. Hotek and spend a lot of time on the practice exams on the...

Today, I passed the exam. Cha Cha Cha!

Ofcourse, there is stil so much to know....but studying towards certification motivated me to learn a lot right up front.

Additional reflections...

Thanks to you both. I will check how I configured transactional replication and get back to you.

OK, so if I detach or...

So, 'read-only' is the state that a snapshot database is in only until it's been RESTORED(*edit: er, REVERTED')! Who doesn't know that????? 🙂 Thanks.

** second edit: read...

OP stands for me, the Outstanding Person, I believe 🙂

OK, and what if the source database is corrupted, ie. a virus attack that deleted tables and data, but not the...

Well, cool, Paul, you...

Yes for sure. From my reading I am made to understand that a restored DB snapshot is 'read-only'. Iin the same breath of a page I read that...

doobya (7/23/2010)

---

I like the rule "never do anything you can't undo"

if, after dropping the database your restore had failed ...

... a safer approach would be to: detach db, rename mdf/ndf/ldf,...

OK, got the part about speed but I'm tripping on "read-only". That doesn't sound fully functional.

roll back and roll forward is the 'recovery' part of a restore (or bringing database online after a server restart), it brings the database to a consistent state. It guarantees...

George Sibbald, thanks once again. That worked!

I forgot to restore the log and the transactions were rolled back edit* dev environment. I assume this means...