Viewing 15 posts - 2,701 through 2,715 (of 9,241 total)
Would check your replica names if i were you, seems you're using O and not 0 in some of the replica names and that's likely why it fails
ALTER AVAILABILITY GROUP...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2014 at 7:38 am
assuming you're sorted now??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2014 at 6:41 am
Firstly, why are you using a disk based quorum?
How many nodes are in the cluster?
Are they geographically dispersed?
To remove the quorum disk, reconfigure the quorum type with failover cluster manager...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2014 at 3:51 am
HanShi (11/24/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2014 at 3:49 am
the sql server ntfs permissions are secured by the use of either local groups in ealier versions of windows or by virtual server accounts for Windows 2008 on. As the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 22, 2014 at 7:19 am
incidentally is this an iSCSI storage system or FC?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 1:05 pm
PhilipC (8/7/2014)
Perry Whittle (8/7/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 12:55 pm
run them in same query window as that has the single connection
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 12:47 pm
Wayne West (11/21/2014)
Perry Whittle (11/21/2014)
If you're talking transparent database encryption then Exprsss edition is not going to provide this. It's an Enterprise feature only
I will not deploy Express for something...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 10:16 am
are you running the restore within the same window as the prvious commands?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 10:11 am
If you're talking transparent database encryption then Exprsss edition is not going to provide this. It's an Enterprise feature only
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 9:13 am
Maddave (11/21/2014)
There is still one or more connections to the database. Exec sp_who2 and look to see what connections are connected to your database.
Not if this completed successfully
USE [master]
ALTER...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 9:05 am
Siberian Khatru (11/21/2014)
1. How does switching TDE on affect the backup set(s) for a database?
Once TDE is enabled in the database all backups will be dependant upon the certificate...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 8:28 am
sminar (11/21/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 8:15 am
plamannkathy (11/21/2014)
USE [master]
RESTORE DATABASE [TESTFULL] FROM DISK = N'TESTFULL_FULL_20141120_190322.bak'
WITH FILE = 1, NORECOVERY,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 8:12 am
Viewing 15 posts - 2,701 through 2,715 (of 9,241 total)