Browse by Tags

SQL Server 2005 Database Mirroring choosing optimum value for auto-failover timeout?

Published 12 May 8 4:25 AM | SSQA.net

Choosing a better plan to reduce outage to your database application is a beginner to provide High Availability to your application, irrespective to database or server. You may be aware that SQL Server 2005 version provides the database mirroring which...

Filed under: sql server, databases, best practices, database mirroring, 2005, principal, witness, mirror, timeout

FIX: You must restart the SQL Server service on the principal server after you resume the SQL Server service process from a debug tool in SQL Server 2005

Published 17 December 7 7:19 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications FIX: You must restart the SQL Server service on the principal server after you...

Filed under: sql server, services, kba, alert, database mirroring, principal, restart, debug

FIX: Transactions that are being committed on the principal server may not be copied to the mirror server when a database mirroring failover occurs in SQL Server 2005

Published 26 September 7 3:34 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, kba, database mirroring, principal, transactions, mirror, failover

FIX: Error message when you use SQL Native Client to connect to an instance of a principal server in a database mirroring session: "The connection attempted to fail over to a server that does not have a failover partner"

Published 21 September 7 9:53 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, instance, kba, connections, database mirroring, principal, native

Get basic Database Mirroring information- principal or mirror

Published 19 August 7 5:32 PM | SSQA.net

SELECT DB_NAME(database_id) AS 'DatabaseName' , mirroring_role_desc , mirroring_safety_level_desc , mirroring_state_desc , mirroring_safety_sequence , mirroring_role_sequence , mirroring_partner_instance , mirroring_witness_name , mirroring_witness_state_desc...

Filed under: sql server, high availability, database, database mirroring, tsql, principal, witness, mirror

Control metada visibility using few 'simple' statements

Published 9 August 7 5:3 AM | SSQA.net

You may be aware that a user in a SQL Server 2005 database can only see metadata that the user either owns or on which the user has been granted some permission. A default policy enhanced as compared to how a DBA can control the security access to the...

Filed under: security, access, view, tsql, principal, privileges, metadata

Script to find out all the groups contain in the login token for every server principal

Published 17 July 7 10:44 AM | SSQA.net

The following query will get you the information to find out the groups that contain user login token on that server principal: SELECT name , usage , type FROM sys.login_token ORDER BY usage , type , name go To find any Windows principal in the token...

Filed under: sql server, security, users, login, script, token, principal