Viewing 15 posts - 1,381 through 1,395 (of 9,244 total)
Rich Mechaber (2/5/2016)
If you use a third party tool, you will have to guess, test, and verify that what you thought you told the tool to do actually happened.
Not in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2016 at 6:54 am
Luis Cazares (2/8/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2016 at 6:50 am
so each node has a standalone instance of sql server?
can you supply the scripts you used to apply the read only routing configuration?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2016 at 5:29 am
:Whistling: I posted the link to that at the beginning of this topic on my very first post :w00t:
At no point does it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2016 at 4:43 am
Welsh Corgi (2/8/2016)
Perry Whittle (2/8/2016)
take a new backup of the certDon't I need a password? :unsure:
You only need a password for decryption during the backup if the cert is protected...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2016 at 4:40 am
kenny 40254 (2/8/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2016 at 1:54 pm
take a new backup of the cert
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2016 at 11:15 am
kenny 40254 (2/7/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2016 at 11:13 am
to restore the database to another server you'll need to backup the cert with the private key. You then restore this on the target server, this link details the process
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2016 at 10:55 am
alex.sqldba (2/8/2016)
I am now having a problem with Read only routing but ill put that in another post as not really relevant in this thread
post up a much detail as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2016 at 10:45 am
DBADave (2/5/2016)
It is a database owner, not a database creator, and not a local admin.
Tis the same thing, db_owner provides the power to backup and restore the database, restore...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2016 at 1:23 am
Phil Parkin (2/5/2016)
maybe turning on IFI might help you.
As long as it's not a log file growth issue
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2016 at 1:11 am
C Schaefer (2/5/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2016 at 1:09 am
Again, pausing the cluster node is not recommended. If you happen to have other cluster resources running in this node you'll initiate a failover.
The link posted from Microsoft describes the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2016 at 8:29 am
sgrimard (2/5/2016)
So turn off Auto-Growth on LDF? What would you set...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2016 at 8:23 am
Viewing 15 posts - 1,381 through 1,395 (of 9,244 total)