Microsoft SQL Server

SQL Server Core Engineer Tips

Browse by Tags

Related Posts
  • Blog Post: Use a DNS alias for SSAS 2005/2008 instance

    You would like to configure a DNS alias (CName) for each server to redirect transparently clients for high availability. There is no indication against to use a DNS alias, you can use CNAME to connect to SSAS 2005 or greater. However there are some considerations to take into account. 1. Be carefully...
  • Blog Post: Moving Database Files on the secondary server in Log Shipping

    Moving Database Files on the secondary server in Log Shipping You are using Microsoft SQL Server Logshipping for one of your VLDB (very large database). You would like to move data files on another disk on the secondary server without reconfiguring log shipping. As you cannot use the detach/attach database...
  • Blog Post: Utilisez un alias DNS pour une instance SSAS 2005/2008

    Vous souhaitez configurer un alias DNS (CNAME) pour chaque serveur afin rediriger de manière transparente des clients pour de la haute disponibilité. Il n'y a pas d'indication contre à l'utilisation d'un alias DNS, vous pouvez utiliser un CNAME pour vous connecter à vos...
  • Blog Post: Installation of SQL Server 2005/2008 clusters on Windows 2003/2008

    Installation SQL Server 2005/2008 failover clusters on MSCS Windows 2003/2008 The installation process between SQL Server 2008 and 2005 failover clusters are different. With SQL Server 2008 in cluster you must run the setup process for SQL Server individually on each node of the failover cluster. To...
  • Blog Post: Disaster Recovery Plan using Microsoft SQL Server Logshipping

    Disaster Recovery Plan using Microsoft SQL Server Logshipping The purpose of this post is to give you a quick view of Logshipping with Microsoft SQL Server 2005/2008 for a scenario Disaster Recovery Plan. Description The log shipping is a SQL Server to maintain a backup server to date by applying to...
  • Blog Post: Usar un alias de DNS para una instancia SSAS 2005/2008

    Que le gustaría configurar un alias de DNS (CNAME) para cada servidor para redirigir de forma transparente los clientes de alta disponibilidad. No hay ninguna indicación para utilizar un DNS contra alias CNAME que usted puede usar para conectarse a SSAS 2005 o mayor. Sin embargo hay...