June 21, 2012 at 2:36 pm
hey,
I do not see transaction log shipping option under properties even though i am using enterprise edition.
How can i fix this problem.
Thank you
June 21, 2012 at 2:42 pm
is it possible that you are using the Express version of SSMS to connect to a full blown Enterprise Instance?
if you do Help...About in SSMS, does yours look like this?
Microsoft SQL Server Management Studio 10.0.4000.0
Microsoft Analysis Services Client Tools 10.0.4000.0
Microsoft Data Access Components (MDAC) 6.1.7600.16385
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.4971
Operating System 6.1.7600
Lowell
June 21, 2012 at 2:58 pm
I had express version for my default instance which i have uninstalled ..now only have two instance which are running on enterprise edition. Below are the message that i get after running Select @@version command.
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
June 21, 2012 at 3:02 pm
does the account you are using have sysadmin rights, that right is required.
Another thread on the same issue it turned out to be due to a bad install file, after downloading the software again and reinstalling logshipping was available.
---------------------------------------------------------------------
June 21, 2012 at 3:54 pm
Will you run this and post the results:
select serverproperty('edition') as Edition
,serverproperty('productversion') as ProductVersion
,serverproperty('productlevel') as ProductLevel
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 21, 2012 at 5:32 pm
Yes i am using SA account...
June 22, 2012 at 1:55 am
jatinder_singhs (6/21/2012)
I had express version for my default instance which i have uninstalled ..now only have two instance which are running on enterprise edition. Below are the message that i get after running Select @@version command.Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
Ah Eval edition.
There was one person who had the same issue, where Eval didn't allow for LogShipping of Mirroring. In the end they got a copy of the Developer edition of the software which gave them LogShipping and Mirroring options.
Its a strange one as Eval should be a direct copy of Enterprise but it seems not to be the case. Cant personally comment as I dont have an Eval installation, they are all Developer installations.
June 22, 2012 at 2:11 am
Anthony, is that the same thread I referred to?
http://www.sqlservercentral.com/Forums/Topic1303857-391-2.aspx
I can't see where he says he switched to developer edition from evaluation edition
---------------------------------------------------------------------
June 22, 2012 at 2:14 am
Nope, but yes.
I forgot about that case, I will make that 3 instances I have seen this now then.
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply