We could put a posting guide, though I'm not sure many people will read it.

I think I'll re-run this once a month or so to keep it active in...

You can use SQLExpress as a witness. I'd set an instance of that on another server and configure that.

No idea. I hadn't noticed or bothered with it. I suspect that it's something that is used in some forums to note which items are helpful and which not.

I tend...

That's data quality in Alaska for you!

Must be those cold data entry fingers that keep making mistakes. 😛

We can recommend it, but not sure many people will read it. Lots of people want to get an answer, post quickly, don't think about reading anything, including the sign-up...

What typically happens is you decide to make a new backup to a file and click "Add" and specify a new file in the backup dialog, it's the selected file,...

Doh!

That one always gets me. Must be my accent 😉

We also did an article recently on this.

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

Perhaps you should reschedule if you're not sure which exam you're taking.

Microsoft has the requirements on their site. Search for MCITP Database Developer Certification

Congrats!

I thought 431 was the hardest, but I worked on a book for 443, so that might have helped 🙂

Good luck Gail!

JJ B,

Excellent points and I think I'll actually move into 2 parts from here. One on getting/deciding on requirements and another on the modeling.

Steve

I've seen production servers with 250 databases on them.

As mentioned above, the number of databases doesn't matter. It's what they are doing.

You will want to restore any logs on the secondary that haven't been restored. If you can't get the tails off the primary, then you are stuck and just need...

I'd use the DTS/SSIS wizard. Easier to set this up once, then you can periodically run it against the tables.

You could BCP out/in, http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30027/, use the select from sysobjects to...

You can grant the CREATE TABLE right to someone. Preferably to a role.

http://www.databasejournal.com/features/mssql/article.php/3379521