January 19, 2015 at 4:21 pm
Hi,
While trying to mirror a database...
After getting full backup and restoring to backup server the mirror server enters in (Restoring...) state.
This is needed to start mirroring.
But to setup mirroring I need to right click to database and open properties dialog, when I try it I got:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
------------------------------
Property MemoryAllocatedToMemoryOptimizedObjectsInKB is not available for Database '[MyDatabase]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (SqlManagerUI)
January 20, 2015 at 5:17 am
What kind of permission you do have on server and databases?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 20, 2015 at 5:22 am
What is the exact version of the server? Both principal and mirror (SELECT @@Version)?
What is the version of SSMS you're using (Help -> About)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2015 at 6:45 am
Microsoft SQL Server - 12.0.2464.0
Microsoft SQL Server Management Studio - 12.0.2464.0
Microsoft Analysis Services Client Tools - 12.0.2464.0
Microsoft Data Access Components (MDAC) - 6.3.9600.17415
Microsoft MSXML - 3.0 6.0
Microsoft Internet Explorer - 9.11.9600.17498
Microsoft .NET Framework - 4.0.30319.34014
Operating System - 6.3.9600
---------------------------------------------------------------------
It's not important how I connect to the database:
Both tried Windows Authentication (Administrator) and SQL Server Authentication (sa)
---------------------------------------------------------------------
When I restore it normally (RESTORE WITH RECOVERY), I can right click on database and open properties box but can not setup mirroring due to wrong restore option.
When I restore it with "RESTORE WITH NORECOVERY", database is ready to setup with mirroring (Restoring... state) but this time I can't open properties window, giving errors.
January 20, 2015 at 6:53 am
And the results of SELECT @@Version on both principal and mirror?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2015 at 7:09 am
Principal and Mirror are both twin servers in everyway.
Both have version (@@Version):
Microsoft SQL Server 2014 - 12.0.2464.0 (X64)
Dec 19 2014 17:59:51
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )
January 20, 2015 at 7:19 am
Ok, not an SSMS version mismatch.
Offhand, not sure. Have you tried doing the mirroring setup in T-SQL instead of the GUI?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 20, 2015 at 7:31 am
I didn't try that yet (Mirroring by T-SQL)
This is probably a bug in SSMS.
I've some idea about how this might happened:
In the principal server, I've some other databases which I made test with Memory Optimized Tables and Native Compiled Stored Procedures.
May be when I use these functions/properties of SQL Server 2014, SSMS will create some helper stored procedures or views or functions like "MemoryAllocatedToMemoryOptimizedObjectsInKB" in master. And can't find those in mirror because mirror hasn't got any "memory optimised tests" on it.
So I'll create a test db on mirror server and create some "memory things" then try to right click again... And let you know...
January 22, 2015 at 2:41 am
"memory thing" didn't help.
So only Mirroring by T-SQL mode left.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply