Browse by Tags

• bi
• bids
• clustering
• database
• database mirroring
• disaster
• error
• failover
• geographic
• Installation
• Integration
• kba
• mirror
• msdtc
• not found
• performance
• performancepoint
• principal
• recovery
• security
• server
• SSMS
• surface
• tips
• tsql
• witness
• x64

• Number of databases limit for Database Mirroring within X64 environment?

  We have had a request from one of the solutions company stating they have to mirror 15 SQL Servers that are dispersed across the European locations to a central location. For this they have deployed the X64 environment for operating system and SQL Server Read More... Posted Thursday, August 30, 2007 8:27 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, x64, server, database mirroring, high availability, geographic

• Data Protection and Disaster Recovery Tips

  How to protect and secure data in the event of a disaster? It's not possible to anticipate every possible disaster your organization may encounter, but you don't have to. Discover a wealth of information about how to protect and secure your data in the Read More... Posted Tuesday, August 28, 2007 8:54 PM from SSQA.net | (Comments Off) Filed under: SQL Server, server, recovery, high availability, tips, disaster

• How to rebuild or move a MSDTC installation to be used with a SQL failover cluster

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications How to rebuild or move a MSDTC installation Read More... Posted Wednesday, August 22, 2007 7:03 PM from SSQA.net | (Comments Off) Filed under: SQL Server, Installation, kba, high availability, msdtc, clustering, failover

• [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). [ODBC SQL Server Driver][DBNETLIB]Specified SQL server not found

  --------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' Read More... Posted Wednesday, August 22, 2007 12:06 AM from SSQA.net | (Comments Off) Filed under: security, SQL Server, Integration, SSMS, error, high availability, surface, not found

• Get basic Database Mirroring information- principal or mirror

  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 Read More... Posted Monday, August 20, 2007 8:32 AM from SSQA.net | (Comments Off) Filed under: SQL Server, tsql, database, database mirroring, principal, high availability, witness, mirror

• BI - PerformancePoint Server LAST CTP announced!

  Microsoft released PerformancePoint Server’s LAST Community Technical Preview (CTP) before launch! To date, the CTP program has gathered close to 10,000 members and the product has been enjoying fantastic pre-launch press and analyst coverage. For more Read More... Posted Friday, August 17, 2007 1:32 AM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, performancepoint, bi, bids, high availability