Viewing 15 posts - 196 through 210 (of 1,271 total)
pradeep.mohan (8/1/2012)
Thanks Robert....So 'Local System Account' is the better way to use for SQL Server service and SQL Agent service account? for mirroring.
No! A non-user DOMAIN ACCOUNT is the best...
August 2, 2012 at 12:00 am
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...
August 1, 2012 at 8:39 am
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...
August 1, 2012 at 8:20 am
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...
July 31, 2012 at 5:13 pm
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...
July 31, 2012 at 8:16 am
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...
July 31, 2012 at 7:55 am
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...
July 31, 2012 at 7:53 am
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...
July 31, 2012 at 7:48 am
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...
July 31, 2012 at 7:38 am
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...
July 22, 2012 at 12:07 pm
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.
July 22, 2012 at 11:19 am
Perry Whittle (7/22/2012)
http://www.sqlservercentral.com/articles/Database+Mirroring/72294/[/url]
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...
July 22, 2012 at 7:53 am
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...
July 22, 2012 at 7:33 am
Perry Whittle (7/22/2012)
July 22, 2012 at 7:29 am
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...
July 22, 2012 at 7:26 am
Viewing 15 posts - 196 through 210 (of 1,271 total)