Viewing 15 posts - 2,086 through 2,100 (of 9,241 total)
a master key already exists, so you don't need to create another. Just create the cert in the master database.
What is it you are attempting to do, are you trying...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2015 at 5:17 am
first you'll need to check that the secondary has been restored to the appropriate point in time then join it to the availability group
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2015 at 5:16 am
yes, you can script the alter database commands quite easily using the system catalog sys.master_files 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2015 at 5:15 am
What's wrong with just using sp_detach_db and create database for attach?
If all you're doing here is detaching to move files then this is totally unnecessary anyway and is an old...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2015 at 1:51 am
or without the join
select db_name(database_id), name, physical_name
from sys.master_files
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2015 at 1:19 pm
William Soranno (5/26/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2015 at 1:16 pm
this demand is usually because they do not understand exactly what permissions are required or cant be bothered to maintain granular security, it's not an excuse
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2015 at 1:11 pm
If you install the clustered instance as evaluation edition and then wish to upgrade there will be an issue. This link details the upgrade paths from evaluation to
SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2015 at 6:30 am
SQL-DBA-01 (5/22/2015)
I found that some1 accidentally did nt mention d expiry date against each certificate so by default it took 1 yr of expiry.
Is there anyway I can...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 22, 2015 at 8:59 am
Arestas (5/21/2015)
The architecture i am trying to implement is as follows:
3 Servers. 2 in primary site and 1 in a secondary...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 22, 2015 at 8:52 am
feersum_endjinn (5/21/2015)
No, the cluster nodes are (rather will be) located in the same data centre, same room, same VM hosts.
Ok, got it
feersum_endjinn (5/21/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 22, 2015 at 8:40 am
I was hoping to see a discussion on the impact to the host server of adding too many vNICs, vDisks and virtual disk controllers to VMs. Is this something you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2015 at 11:30 am
feersum_endjinn (5/19/2015)
But now I understand that this is supported and it's in fact desirable to have anyway.
Ideally, no it's not. You don't want shared replicated storage. It's expensive, requires maintenance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2015 at 10:56 am
feersum_endjinn (5/19/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2015 at 10:55 am
Martin Stephenson (3/14/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2015 at 9:54 am
Viewing 15 posts - 2,086 through 2,100 (of 9,241 total)