Browse by Tags

• backups
• database
• datareader
• geographic
• high availability
• kba
• mirror
• oledb
• overview
• performance
• principal
• Reporting Services
• server
• snapshot
• SQL Server
• tsql
• webcast
• 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

• The following KBA pages were recently modified - SQL Server 2005 webcasts

  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 Support WebCast: How to use the DataReader Read More... Posted Monday, August 27, 2007 9:17 PM from SSQA.net | (Comments Off) Filed under: SQL Server, backups, webcast, database mirroring, kba, oledb, overview, datareader

• 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

• When to use mirrored server as a reporting server?

  IN the case of production server which is running 24/7 and can't afford any downtime, it is good to keep the mirrored server for reporting purpose. Say if the requriement is to have r eporting server that should be updated with data from production server Read More... Posted Wednesday, August 08, 2007 6:09 PM from SSQA.net | (Comments Off) Filed under: Reporting Services, SQL Server, database mirroring, snapshot