Viewing 15 posts - 3,031 through 3,045 (of 9,244 total)
faisalfarouqi (8/22/2014)
Possibly, in a week's time we are to migrate around 4 sql clustered instances from the old box to the new cluster. However, what migration meant for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2014 at 4:58 am
you can do this and will need to make use of certain sysprep tools to change key OS system IDs. Renaming the sql server computername is the easy part 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2014 at 9:18 am
Read-intent is not a Primary role option. The only options for the primary role are
allow read\write connections, this will basically...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2014 at 9:16 am
The only real gotcha i've noticed when going from SQL server 2008 to SQL server 2012 or higher is the identity\sequence issue. If you have columns that use an identity...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2014 at 9:02 am
Duran (8/21/2014)
I'm not doing T-Log backups (yes I know, lets leave that for now!).Thanks in advance.
D.
Are you saying you've disabled the log shipping agent backup jobs??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2014 at 6:20 am
Which Windows operating system are you currently using and which edition of sql server 2008 R2?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2014 at 5:04 am
the users should just require the relevant permission on the cert itself
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2014 at 3:34 am
post the solution i sent you by PM
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2014 at 3:28 am
Pm Steve Jones the moderator
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2014 at 11:49 pm
arnipetursson (8/21/2014)
One more question.If you do not have access to server B beyond db_owner in the database,
how do you ensure that the logins (server principals) are synced?
Curious, how did you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2014 at 11:47 pm
Brandie Tarvin (8/21/2014)
On another note, I recently found that I can also just break the mirror from either the primary or the secondary
Yes, hence my comment
comment
Perry Whittle (8/19/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2014 at 11:37 am
it depends completely on demand. If the recruiter can afford to wait they'll try to offer a much lower rate. If they need someone quick and the client likes the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2014 at 5:35 am
you're welcome, don't forget to mark the post as solution to help others
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 21, 2014 at 4:46 am
run a couple of log backups in succession and try delete the file again
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2014 at 7:27 am
SequelSurfer (8/20/2014)
Yes - with no mirroring set on it, just a normal database. Need to remove the mirror copy so we can backup/restore the principal and reset mirroring.
If the original...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2014 at 7:11 am
Viewing 15 posts - 3,031 through 3,045 (of 9,244 total)