Viewing 15 posts - 3,031 through 3,045 (of 9,241 total)
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
emptyfile does not apply to transaction logs.
is the database in simple or full recovery?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2014 at 6:55 am
Is the original principal back online?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2014 at 6:52 am
John Mitchell-245523 (8/18/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2014 at 5:48 am
Viewing 15 posts - 3,031 through 3,045 (of 9,241 total)