Viewing 15 posts - 5,566 through 5,580 (of 9,253 total)
erm, how about the Microsoft website 😉
May 14, 2012 at 1:54 pm
Automatic failover is only possible with a witness and high safety mode.
May 14, 2012 at 1:43 pm
capn.hector (5/14/2012)
we fixed it by detaching the database with sp_detach_db rename the log file then sp_attach_single_file_db. it worked and we can now shrink the file.
Bad idea generally.
A quick check...
May 14, 2012 at 11:49 am
AK1516 (5/14/2012)
I have no differential backups running.
You may not be able to run differentials all week, but you may get away with running 2 full backups per week and differentials...
May 14, 2012 at 11:08 am
with replication you have a manual failover action, depending upon your mirror session type this will also be either manual or automatic failover. For sessions using a witness you may...
May 14, 2012 at 10:29 am
AK1516 (5/14/2012)
May 14, 2012 at 10:25 am
why not just use the system function fn_varbintohexstr()
May 14, 2012 at 4:40 am
Yes, fail over cluster instances may participate as an availability replica in AlwaysOn availability groups. Think of it like this
You have a WSFC comprising of 3 nodes. You have a...
May 12, 2012 at 12:18 pm
derekr 43208 (5/12/2012)
Perry Whittle (5/12/2012)
derekr 43208 (5/12/2012)
From what I understand, it uses Failover Clustering,...
May 12, 2012 at 10:14 am
derekr 43208 (5/12/2012)
Which configuration Provides Database Level redundancy including Hardware Redundancy(Clustering)Thanks
AlwaysOn availability gropus provide redundancy at the database (or a group databases) level.
A failover cluster instance provides protection at the...
May 12, 2012 at 9:07 am
derekr 43208 (5/12/2012)
From what I understand, it uses Failover Clustering, without the shared storage
Is...
May 12, 2012 at 8:51 am
derekr 43208 (5/8/2012)
A question regarding the SQL 2012 High Availibility Features
I understand that in order to use the High Availibility Features that comes with SQL 2012, the Servers need...
May 11, 2012 at 9:13 am
be honest with you i've never it tried it hat way but cant see it wouldn't work, give it a go it'll either work or it won't
Download SP3 and CU4...
May 11, 2012 at 8:51 am
my first temptation would be to re run the instance configuration and re create all the procedures, if you're still having issues after that maybe check with Quest support
May 11, 2012 at 8:15 am
Ok, so you can leave DTC running locally as Elliott has pointed out and that's fine for some scenarios but this can affect in flight transactions though upon a failover,...
May 10, 2012 at 4:47 pm
Viewing 15 posts - 5,566 through 5,580 (of 9,253 total)