Viewing 15 posts - 9,346 through 9,360 (of 9,725 total)
Adam,
Theoretically, you might be right, but in the past I've actually seen an exam where they gave me an example of a database in Simple recovery mode and started off...
October 30, 2007 at 9:14 am
Becase as long as you pass, you pass, regardless of the exam version. @=)
And if you make a note on the Betas (or an exam) about a problem being wrong...
October 30, 2007 at 9:11 am
Ditto to Adam's post.
When I was still working retail / customer service, I created Access databases to track my supply orders and other items. I didn't need to do...
October 30, 2007 at 8:08 am
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...
October 30, 2007 at 7:24 am
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,...
October 30, 2007 at 5:46 am
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...
October 30, 2007 at 5:03 am
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/
October 30, 2007 at 4:48 am
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...
October 30, 2007 at 4:43 am
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...
October 30, 2007 at 4:32 am
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,...
October 30, 2007 at 4:18 am
I've never used MOM or OnePoint before. Did you check your logs for specific error messages? Both SQL Server and OS logs?
October 29, 2007 at 12:33 pm
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...
October 29, 2007 at 12:26 pm
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...
October 29, 2007 at 11:39 am
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...
October 29, 2007 at 10:40 am
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...
October 29, 2007 at 5:06 am
Viewing 15 posts - 9,346 through 9,360 (of 9,725 total)