No announcements
Categories
-
Select allSQL Server Integration ServicesData MiningSQL Server Reporting Services, Power ViewSQL Server Analysis ServicesSQL Server ToolsTransact-SQL.NET Framework inside SQL ServerSQL Server Data AccessSQL Server SMO/DMOSQL Server XMLSQL Server ReplicationSQL Service BrokerSQL Server SecuritySQL Server Database EngineSQL Server DocumentationSQL Server Setup & UpgradeSQL Server High Availability and Disaster RecoverySQL Server Notification ServicesSQL Server CompactGetting started with SQL ServerDatabase MirroringSQL Server ExpressMicrosoft Drivers for PHP for SQL ServerSQL Server Data WarehousingSQL Server SearchSQL Server SpatialSQL Server Samples and Community ProjectsMicrosoft StreamInsightDatabase DesignSQL Server MigrationSQL Server Master Data ServicesSQL Server Application and Multi-Server ManagementSQL Server PowerPivot for ExcelSQL Server PowerPivot for SharePointSQL Server ManageabilitySQL Server Distributed ReplaySQL Server Data Quality ServicesMicrosoft HDInsight (Windows and Windows Azure)SQL Server Data Tools
-
Select allAnnouncements for all ForumsForums Redesign - Q&A / DiscussionsWhere is the Forum For…?Forums Issues (not product support)Suggestions and Feedback for the ForumsOff-Topic Posts (Do Not Post Here)MSDN and TechNet Profile and Recognition System Discussions
-
Select allVisual C#Visual BasicVisual C++C++ Standards, Extensions, and InteropParallel Computing in C++ and Native CodeVisual F#Microsoft "Roslyn" CTP
-
Select allVisual Studio General QuestionsVisual Studio Setup and InstallationVisual Studio ExtensibilityVisual Studio Tools for OfficeVisual Studio EditorMSBuildVisual Studio LightSwitch ExtensibilityVisual Studio LightSwitch - General QuestionsLightSwitch HTML Client PreviewVisual Studio Visualization & Modeling ToolsTesting with Visual Studio Test Manager (MTM)Test Tools in Visual Studio 2010 and 2012Visual Studio Unit TestingVisual Studio Diagnostics (Debugger, Profiler, IntelliTrace)Visual Studio Tools for Applications (VSTA)
-
Select allUI Design for Windows Store appsTailoring your Windows Store app for hardware and devicesBuilding Windows Store apps with HTML5/JavaScriptBuilding Windows Store apps with C++Building Windows Store apps with C# or VBBuilding Windows Store games with DirectXTools for Windows Store appsPublishing Windows Store apps
-
Select allApplication Compatibility for Windows Desktop DevelopmentDeveloping Windows Desktop Applications with Power ManagementWindows Desktop Development for Accessibility and AutomationDirectShow DevelopmentGeneral Windows Desktop Development IssuesWindows Desktop Development for Ink, Touch, and Tablet PCMedia Foundation Development for Windows DesktopMicrosoft Message Queuing (MSMQ)Network MonitorWindows Desktop Optical Platform DiscussionPeer-to-Peer Networking for Windows DesktopApplication Security for Windows DesktopWindows Desktop Sidebar Gadget DevelopmentUser Interface development for Windows DesktopVisual C++Windows Desktop DebuggingWindows Desktop Search DevelopmentWindows Desktop Search HelpWindows Filtering Platform (WFP)Windows Imaging Component (WIC)Windows Desktop Perfmon and Diagnostic toolsWindows Desktop Pro-Audio Application DevelopmentWindows Desktop SDKWindows Desktop Web Services API (webservices.dll)Windows Desktop Winsock Kernel (WSK)Windows Hardware WDK and Driver DevelopmentDevelopment with the Windows Sensor and Location PlatformWindows Desktop Ribbon DevelopmentWindows Hardware Testing and CertificationC++ Standards, Extensions, and InteropMessage Analyzer
-
Select allDeveloping for Windows PhoneTools for Windows Phone developmentShare your "How To" samplesPush NotificationsIn-App AdvertisingMango Update (Archived)Expression Blend for Windows Phone
-
Select allDeveloping Apps for Office 2013General Office DevelopmentAccess for DevelopersExcel for DevelopersOutlook for DevelopersWord for DevelopersOpen XML Format SDKVisual Studio Tools for Office
-
Select allWindows Azure DevelopmentWindows Azure Troubleshooting, Diagnostics & LoggingWindows Azure Storage, CDN and CachingWindows Azure SQL DatabaseConnectivity and Messaging - Windows AzureManaging Services on Windows AzureSecurity for Windows AzureWindows Azure Purchasing, Pricing & BillingWorkflow Manager 1.0Service Bus 1.0Windows Azure Active DirectoryWindows Azure Active AuthenticationWindows Azure Media ServicesWindows Azure BizTalk ServicesWindows Azure Virtual NetworkWindows Azure Virtual Machines
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Unanswered0VotesUnable to connect to Witness after hardware failure (SQL 2005)
Hi All, I do have 4 production servers for mirroring and 1 witness server as information below and all are working fine :- (Principal : SQL2 , Mirror ...
-
Answered0Votes
How Pausing and Resuming Mirroring Affects Log Truncation
What i understand is that in Full Recovery model there is only one way to truncate the log and that is via a transaction log backup. The checkpoint process is only for Simple Recovery Model. Then, why ... -
Proposed0Votes
database in emergency mode
Dear All, My database was in emergency mode so i need to bring it back to normal mode. How to bring the database back from emergency mode my database size is 350 ... -
Answered0Votes
SQL Database Mirroring
We have a SQL 2008 R2 Standard Edition server running on a two node Active Passive Fail Over Cluster (Windows 2008 R2). For DR purposes, we would like to have mirroring setup on another SQL Server, ... -
Answered0Votes
Is the witness server and instance of MS SQL Server?
Is the witness server and instance of MS SQL Server? Mr Shaw -
Answered0Votes
Move mirror without breaking it
Greetings. Can anyone suggest me the options to move the mirror from one SQL server instance to another without breaking the mirror and downtime. Thanks in ... -
Answered0Votes
sql database mirroring, different version
can i use different version of sql server for database mirroring. let say, principle is sql 2008r2 and mirror is sql 2012. witness is server sql ... -
Unanswered1Votes
status disconnected
Hi, The sql 2008 R2 sp2 high performance mirroring became disconnected. It seems was caused by mirror server restarted. The mirroring settings was on port 5022. ... -
Answered0Votes
True or False statment to a mirrored solution?
Hi, We have this code and it basically fails as it appears to be validating the 2nd statement to see if the database is accessible or not - however surely with the code written it ... -
Answered0Votes
Troubleshooting Steps Link for Database Mirroring
Dear Link, I want to know troublshoot steps link to layman understand easily. Please share it if possible. -
Answered0Votes
how to deal with the stale connection when failover happens ?
The exception for the Scenario #5 in the following article is "because the connection in the pools has no knowledge of the failover that has happened, it still assumes that Server_A is ... -
Answered0Votes
how to destroy the stale connection when we have a failover.
The exception for the Scenario #5 in the following article is "because the connection in the pools has no knowledge of the failover that has happened, it still assumes that Server_A is up and ... -
Proposed0Votes
Transfer logins
Hello. I need some help automating transfer of logins from principal server to mirror server (SQL Server 2008 R2) using a SQL Agent job. I want to use sp_help_revlogin to dump a list ... -
Unanswered0Votes
Mirroring - The server instance Partner rejected configure request
I configured Mirroring with no witness between 2 SQL Server 2008 R2 for about 48 databases mirrored. Recently, I found out this error in the windows event log occuring days and ... -
Proposed0Votes
How to reduce network latency during mirroring?
We are using SQL Server 2008 R2 Standard edition for mirroring. But we found out that network latency is too high. It takes nearly four times time to complete a transaction while ... -
Answered0Votes
Using SQL Server in Informatica PowerCenter
How can I use SQL Server with Informatica, for what I understand using the Informatica PowerCenter Server and SQL requires the Login Name, Password and Port Number, what is the Port Number for SQL? -
Answered0Votes
Moving back database to restoring mode
Hi, Is there any way can we move back the online database to Restoring mode on SQL 2008 R2? Thanks & ... -
Proposed0Votes
FQDN Error with Error 1418 and Error 1408 when configuring mirror on work group pc
I configured mirror on work group PC without witness server so when I start mirroring i get error one or more of the server network address lack a ... -
Answered2Votes
The remote copy of database has not been rolled forward to a point in time that is encompassed in the local copy of the database log.
I am able to setup the partner on the mirror with no problems. I receive the error message when I try to setup the partner on the principal. I have restored the log file with no recovery, ... - Items 1 to 20 of 1943 Next ›
