Viewing 15 posts - 2,131 through 2,145 (of 9,253 total)
Paresh Motiwala (5/13/2015)
But I was looking for a PowerShell based solution.
You're not a powershell expert so why would you want complicated, involved scripts to do this instead of the GUI???
Paresh...
May 13, 2015 at 9:12 am
Markus (4/21/2015)
Some say you must use the Config Manager for the active node
Correct
Markus (4/21/2015)
then update it on the passive node via the Services panel.
Incorrect and I'll tell you...
May 13, 2015 at 4:17 am
vrmutyala (5/12/2015)
There are 21 instances on 6 of the nodes and one node is passive.I came up with the following steps:
1. Shutdown the Passive Node.
Ok so far
vrmutyala (5/12/2015)
May 13, 2015 at 4:11 am
you'll need to perform a DTC reset log, the syntax from a command prompt is
msdtc -resetlog
Then restart the msdtc clustered role
May 13, 2015 at 4:02 am
This should be of some help, in parts
http://www.sqlservercentral.com/articles/AlwaysOn/106314/[/url]
May 13, 2015 at 3:54 am
ramana3327 (5/11/2015)
May 12, 2015 at 6:58 am
can you provide full details of the steps you are taking?
May 12, 2015 at 5:09 am
then a reboot will have an impact on the running instances. You'd be best to move them before the reboot so they are unaffected by node1 going offline
May 12, 2015 at 4:51 am
are the running instances clustered?
which node are they active on?
May 12, 2015 at 4:19 am
There is no medianame specified in the query below!
Igor Micev (5/10/2015)
BACKUP DATABASE [F1SB] TO DISK = N'F:\SqlBackup2014\<server>\F1SB\FULL\IGS-DB01_F1SB_FULL_20150510_214455.bak' WITH NO_CHECKSUM, COMPRESSION, ENCRYPTION (ALGORITHM = AES_256,...
May 12, 2015 at 1:17 am
have you re run the backup command specifying a medianame?
May 11, 2015 at 10:43 am
Igor Micev (5/11/2015)
Grant, it's not a permission issue. It's a windows account with sysadmin privileges.
It's still possible to revoke permission to a windows admin, the advantage that being an admin...
May 11, 2015 at 5:02 am
MotivateMan1394 (5/9/2015)
But , I need Automatic Failover. >>> Then I need "Cluster Quorum Configuration - file share witness. "First of all, is it true ?
How many nodes are in the...
May 11, 2015 at 4:52 am
From Books online
SQL Server Books Online
Support for tape backup devices will be removed in a future version of SQL Server. Avoid using this feature in new development work,...
May 8, 2015 at 9:56 am
Joshua D Gang (5/7/2015)
Why does each of cluster nodes have to have its own SPN?
The nodes themselves don't have SPNs, the individual instances have the SPNs configured against each of...
May 8, 2015 at 9:50 am
Viewing 15 posts - 2,131 through 2,145 (of 9,253 total)