Viewing 15 posts - 451 through 465 (of 1,271 total)
Yes, this is fine. If you want automatic failover, you can have B be the witness for A to C and A be the witness for B to C. If...
February 1, 2011 at 11:20 pm
Are you sure there's no activity? I've heard similar reports before but when I looked into it, they had a data archive job that was still running daily and they...
January 14, 2011 at 12:10 pm
Why are you so concerned about the ghost cleanup task?
Ghost cleanup runs in the background at regular intervals. As you stated, frequency depends on the version of SQL you are...
January 14, 2011 at 10:45 am
Sorry, password comes before SID and no single quotes around the SID value.
Create Login [Test]
With Password = 'Passw0rd',
SID = 0xE1EDB47AD4DEB243A4AA578ACBE92700
January 13, 2011 at 7:53 pm
Test is a SQL login not a Windows login? Then you have to make sure that you specify the SID when creating the login on the standby server or it...
January 13, 2011 at 4:22 pm
You can create a user without a login in SQL Server 2005 and newer. However, uyou can se these steps to simplify it for you:
1. Create login on production server
2....
January 13, 2011 at 3:26 pm
That's actually a very good question Low Rider.
The snapshot is a read-only, point-in-time database. As such, the queries run against it do not create locks nor do they honor...
December 4, 2010 at 10:27 am
UMG Developer (11/18/2010)
SanDroid (11/18/2010)
November 18, 2010 at 4:07 pm
rtelgenhoff (10/5/2010)
October 5, 2010 at 1:34 pm
Whether you think SQL Server should be preserving physical order of the data or not doesn't matter. The facts of the case is that it only preserves logical ordering of...
October 5, 2010 at 1:24 pm
Perry Whittle (9/27/2010)
Robert Davis (9/27/2010)
The description sounds a lot like cluster negotiation.Hi
This wouldn't cause the original active node to reboot though would it?
No, it wouldn't. I'd love to see what...
September 27, 2010 at 11:53 am
The description sounds a lot like cluster negotiation. This is when the inactive node thinks that the active node is offline and tries to fail over. The active node refuses...
September 27, 2010 at 2:08 am
I think you're trying to do too much with too little.
Your biggest worry is if the server crashes, and if you lose the secondary server, what good will the log...
September 27, 2010 at 1:01 am
Palmer always starts off slow, and then as soon as you get tired of waiting and bench him, he has a monster game against a team they shouldn't beat.
I can...
September 20, 2010 at 5:10 pm
Viewing 15 posts - 451 through 465 (of 1,271 total)