No! A non-user DOMAIN ACCOUNT is the best...

Who's Gil? The person helping you is named either Gail or GilaMonster. Gil Gerard is not a member of these forums.

The best service account to use for the SQL Server...

The exam says it is still in beta because of the way the Prometric system works. It will say it is still in beta as long as we delay the...

When it an article is in multiple publications, it is tracked separately for each one. So every update to the table will be tracked multiple times. This will cause there...

If you can't do a page level restore, that leaves you with 2 options. You can restore the whole database and renitialize replication to it. Or you try running DBCC...

the best practice here is to not put an article in multiple pulbications. It's bad for performance. Breal it up into smaller publications if you have to and send multiple...

Start with Books Online. Every question you asked is answered in there.

A snapshot is a starting point for replication. Replication can't keep track of every transaction forever, so it needs...

What about SQL Server backups? Symantec BackupExec is not a replacement for creating SQL Server backups. In order to do a page restore, you will need regulr backups including all...

How many databases you can mirror on a single server relies on many factors such as workload, the number of CPUs, the capabilities of the server. You need to test...

I tried several ways to try to escape the embedded single quotes and the call to sp_msforeachtable errors out before those attempts can be made. Writing your own looping mechanism...

Best advice: change the name of the table to not have single quotes in it.

2nd best advice: don't use sp_msforeachtable. Write your own code to loop through the tables.

Ummm, that article clearly states that you have to break mirroring to fix that.

It says:

Once you have defined the filegroup, you need to switch off the mirroring session...

You're right. I doubt it's feasible to even try. Though it is possible to do with Extended Events in SQL 2012. Excellent article on that from Jonathan Kehayias: Tracking Problematic...

Perry Whittle (7/22/2012)

---

You don't need to break mirroring at all. Pause the mirror and then perform a backup on principal and restore with move to mirror then resume mirroring. It's...

That's already covered in the post I linked to. Also covered in that post is an explanation for why using telnet is not sufficient. If telnet succeeds, that only means...