May 21, 2012 at 11:23 pm
Hi All,
I downloaded SQL SERVER 2008 R2 Enterprise Evaluation version & installed for checking some futures.
ISSUE :- I am trying to configure Log-shipping but not able to see future. Let me know, can it is possible to configure in Enterprise Evaluation Version or not...
Thanks in advance...
Satish...
May 22, 2012 at 12:26 am
It is possible.
Could you explain the steps you are trying to configure LS.
Where are you not seeing this future?
May 22, 2012 at 12:45 am
Check this Logshipping configuration steps:
May 22, 2012 at 12:51 am
Hi Eights,
When i click on DB properties i am not getting MIRRORING or LOGSHIPPING option...
Check the attachment of Screenshot..
May 22, 2012 at 1:39 am
Only SysAdmin can configure LS.
May 22, 2012 at 1:52 am
Hi,
Yes, i have sysadmin rights (using 'sa' account)...
May 22, 2012 at 7:17 am
The eval version of Enterprise should be able to do everything that the regular version does. I've never know MS to cripple their demos on ability when they've got a timer on it.
Is this a home network you're setting this up on or a work network?
Are you sure the sa account has permissions to the hard drive shares that are needed?
What type of logins do your service accounts use? SQL Server or Windows?
May 22, 2012 at 8:36 am
whats the recovery mode of the database?
For mirroring it needs to be in full recovery mode, for log shipping bulk or full recovery, else the features (not futures :-)) wont be available
---------------------------------------------------------------------
May 22, 2012 at 8:39 am
george sibbald (5/22/2012)
whats the recovery mode of the database?For mirroring it needs to be in full recovery mode, for log shipping bulk or full recovery, else the features (not futures :-)) wont be available
True but the options are not there on the properties of the database, even with a DB in Simple recovery you should still be able to see the Mirroring and Transaction Log Shipping options, but when you try to configure them thats when it details the error about the recovery model.
The only two things I can think of are, account doesnt have SA right or eval doesn't support mirroring / log shipping.
Granted the OP said that they where logging in as SA, but has SA still got sysadmin rights?
May 22, 2012 at 8:55 am
oops, sorry, that'll teach me to jump to conclusions.
---------------------------------------------------------------------
May 22, 2012 at 9:12 am
Then it has to be something with the SA account. Per this link:
For features supported by Evaluation and Developer editions see the SQL Server Enterprise feature set.
That tells me Eval is not crippled.
May 22, 2012 at 10:38 am
saidapurs (5/22/2012)
Hi,Yes, i have sysadmin rights (using 'sa' account)...
Not sure why LS/Mirroring not appearing.
Anyway try this and see what happens:
1) Check the properties of some other database
2) Use some other login
3) Connect to another SQL Server instance and try to configure Ls (Anyway LS needs two instances and should work from both direction)
4) Try to configure Ls from some other client machine
May 22, 2012 at 11:30 am
You're using the sa login. Have you confirmed that the login still has full sys admin rights?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 22, 2012 at 11:34 pm
Hi All,
I installed 2 instance both are same issue..
I tried on SA & windows authentication (same issue)
SA log-in have SYSADMIN rights.
& one thing REPLICATION is working fine.
Let me know if any details required...
Thanks in Advance....
May 23, 2012 at 4:40 am
The only other thing I can think of is whether or not your services are running under domain accounts or not. Have you checked that?
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply