Honestly, I'm not sure if the snapshot "empties" or is deleted completely once you restore. The best way for you to find out the answer, though, is to test...

Oddly enough, when I was searching yesterday, I could not find the "Forum Settings" Box no matter where I searched on my account or in Control Panel. Yet, today,...

V,

I appreciate the link to Amazon and Microsoft (I didn't know about those books), but...

You'd better amend your post. TestKing, Pass4Sure and BrainDump are all brain dump sites and...

There are no books yet for these exams (I've been looking), but this article was recently published on the site. It might help you out:

http://www.sqlservercentral.com/articles/Business+Intelligence/61369/

Richard,

Are you aiming too high? I don't know. It depends on your retention level and your ability to learn. If you learn quick and retain for a...

Wow. 500+ million records? That's a LARGE table.

I can tell you from experience that the more columns you have in a table that size, the harder it is...

You can't insert into a snapshot. All the snapshot does is "tag" the database at the time the snapshot is taken. Then, everytime something in the database changes,...

I've never used MOM or OnePoint before. Did you check your logs for specific error messages? Both SQL Server and OS logs?

The problem being that my code is going to be a stored procedure once I get done coding it. If I use GO, then I cut my Sproc short...

Well my connection must have been refreshed shortly after posting this because I was demonstrating it for my boss and it worked... DOH. So then I tried a third...

Maybe I should have rephrased my previous post.

When I said "why would you need a transaction log at all", what I meant was, why would you need to hold onto...

To answer your questions the best I can:

As stated above, backups in any version of SQL Server are all online.

Restores, technically, are not online except in the case...

I was under the impression, generally speaking, that the master db doesn't change that much or very often at all. That being the case, why would you need transaction...

Don't forget the hardware issue! Besides restoring over a network, it could be that your DB is taking so long to restore because the hardware is either old or...

SQL Server doesn't really do data comparisons in the literal sense. For that, you're better served by looking into third party tools like Red Gate's SQL Data Compare. ...