Viewing 15 posts - 2,086 through 2,100 (of 9,244 total)
vsuresh (5/27/2015)
After the upgrade can I switch the secondary database back to stand by read only mode?
Only if you upgrade the sql version on the primary too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2015 at 6:20 am
how long has the db been sitting there restoring, if you're unsure initiate a fresh copy of the primary database and replace the secondary
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2015 at 6:19 am
vsuresh (5/26/2015)
Our production server and test server are currently on 2005. We have log shipping in place from production to test server. We are planning to upgrade to 2008 R2....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2015 at 5:29 am
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
Viewing 15 posts - 2,086 through 2,100 (of 9,244 total)