Viewing 15 posts - 2,131 through 2,145 (of 9,241 total)
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
MotivateMan1394 (5/6/2015)
HiI want to setup HA
Read through my stairway to alwayson on this site starting at this link
http://www.sqlservercentral.com/articles/FCI/107536/[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 8, 2015 at 9:06 am
magnus.tengmo (5/8/2015)
I got 5 SQL Servers 2008R2 (2x CPUs with 96-384Gb of RAM) with total 1500DBs and around 10Tb of allocated data. Now I´m forced to upgrade to 2012 and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 8, 2015 at 9:04 am
Have you read my stairway??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 4, 2015 at 11:53 am
Viewing 15 posts - 2,131 through 2,145 (of 9,241 total)