Viewing 15 posts - 2,131 through 2,145 (of 9,244 total)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 13, 2015 at 4:02 am
This should be of some help, in parts
http://www.sqlservercentral.com/articles/AlwaysOn/106314/[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 13, 2015 at 3:54 am
ramana3327 (5/11/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 12, 2015 at 6:58 am
can you provide full details of the steps you are taking?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 12, 2015 at 4:51 am
are the running instances clustered?
which node are they active on?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 12, 2015 at 1:17 am
have you re run the backup command specifying a medianame?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 8, 2015 at 9:50 am
MotivateMan1394 (5/5/2015)
But some say the "NT Service\MSSQLSERVER" is more securable for servers that work on internet
These are essentially local accounts and unless you've configured certificated authentication you won't be able...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 8, 2015 at 9:11 am
Viewing 15 posts - 2,131 through 2,145 (of 9,244 total)