Thursday, January 31, 2008

Cambiar la ruta de donde leer archivos de i386

Cuando se instala Windows la ruta de los instaladores queda en el Registry y aunque copiemos los archivos caundo se agregan y remueven programas se busca la ruta antigua, para cambiarlo haz lo siguiente

 

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion.
El SourcePath es d:\i386\. Cambialo por el directorio local donde están los instaladores y reinicia la computadora

Cómo forzar la replicación con un controlador de dominio específico

Se puede hacer por la interfaz gráfica de la siguiente forma:

 

image

Si no se puede se deberá hacer por línea de comando, tal y como se explica a continuación.

Si se desea replicar con un controlador de dominio específico es necesario realizarlo por línea de comandos por medio del repadmin que está en el Resouce Kit

1. Determine the name of the target server that needs to be synchronized.

2. At a command prompt, use Repadmin.exe to determine the target server's direct replication partners by typing the following command:

repadmin /showreps target_server_name

If the target server can be reached, it displays output similar to the following sample. In this example, DC1 and DC2 are now in the same domain, "support.microsoft.com."

Redmond\DC1
DSA Options : (none)
objectGuid : 4a11d649-f9ab-11d2-b17f-00c04f5cb503
invocationID: 45d18b0b-f9ab-11d2-98b8-0000f87a546b
==== INBOUND NEIGHBORS ======================================
CN=Schema,CN=Configuration,DC=microsoft,DC=com

Redmond\DC2 via RPC
objectGuid: d2e3badd-e07a-11d2-b573-0000f87a546b
Last attempt @ 1999-05-03 18:07.04 was successful.

CN=Configuration,DC=microsoft,DC=com

Redmond\DC2 via RPC
objectGuid: d2e3badd-e07a-11d2-b573-0000f87a546b
Last attempt @ 1999-05-03 18:07.05 was successful.

DC=support,DC=microsoft,DC=com

Redmond\DC2 via RPC
objectGuid: d2e3badd-e07a-11d2-b573-0000f87a546b
Last attempt @ 1999-05-03 18:07.09 was successful.

(Other data excluded because it does not pertain to this article.)

Under the Inbound Neighbors section of the output, the direct replication partners for each directory partition are identified along with the status of the last replication.

3.Find the directory partition that needs synchronization and locate the source server with which the target will be synchronized. Note the objectGuid of the source server.

4.Use Repadmin.exe to initiate replication by typing the following command:

repadmin /sync directory_partition target_server_name source_server_objectGuid

For example, to initiate replication on DC1 so that changes are replicated from DC2:

repadmin /sync dc=support,dc=microsoft,dc=com DC1 d2e3badd-e07a-11d2-b573-0000f87a546b

If successful, Repadmin.exe displays the following message:

ReplicaSync() from source: d2e3badd-e07a-11d2-b573-0000f87a546b, to dest: DC1 is successful.

Optionally, you can use the following switches on the command line:

•/force: Overrides the normal replication schedule.

•/async: Starts the replication event. Repadmin.exe does not wait for the replication event to finish.

•/full: Forces a full replication of all objects from the destination DSA.

 
Initiating Replication Using Active Directory Replication Monitor

1.On the Windows computer that will run the script, install the Windows Support Tools Resource Kit, which includes Active Directory Replication Monitor (Replmon.exe).

2.Start Active Directory Replication Monitor and click Add Site/Server on the Edit menu. Use the "Add Site or Server" Wizard to add the target server to the view.

3.Replmon.exe identifies the directory partitions and displays them as child nodes to the target server in the left pane.

4.Find and expand the directory partition that needs to be synchronized. All domain controllers listed for a given directory partition are source servers, but direct replication partners are displayed with an icon that represents two network-connected servers. Direct replication partners can also be identified by right-clicking a server and clicking Properties. The Properties dialog box displays the source server as a Direct Replication Partner, a Transitive Replication Partner, or a BridgeHead Connection (also a direct replication connection).

5.Right-click the direct replication partner, and then click Synchronize Replica. Replmon.exe initiates replication and reports the success or failure of the request.

  Fuente: http://support.microsoft.com/kb/232072

Cómo forzar la replicación con un controlador de dominio específico

Si se desea replicar con un controlador de dominio específico es necesario realizarlo por línea de comandos por medio del repadmin que está en el Resouce Kit

1. Determine the name of the target server that needs to be synchronized.

2. At a command prompt, use Repadmin.exe to determine the target server's direct replication partners by typing the following command:

repadmin /showreps target_server_name

If the target server can be reached, it displays output similar to the following sample. In this example, DC1 and DC2 are now in the same domain, "support.microsoft.com."

Redmond\DC1
DSA Options : (none)
objectGuid : 4a11d649-f9ab-11d2-b17f-00c04f5cb503
invocationID: 45d18b0b-f9ab-11d2-98b8-0000f87a546b
==== INBOUND NEIGHBORS ======================================
CN=Schema,CN=Configuration,DC=microsoft,DC=com

Redmond\DC2 via RPC
objectGuid: d2e3badd-e07a-11d2-b573-0000f87a546b
Last attempt @ 1999-05-03 18:07.04 was successful.

CN=Configuration,DC=microsoft,DC=com

Redmond\DC2 via RPC
objectGuid: d2e3badd-e07a-11d2-b573-0000f87a546b
Last attempt @ 1999-05-03 18:07.05 was successful.

DC=support,DC=microsoft,DC=com

Redmond\DC2 via RPC
objectGuid: d2e3badd-e07a-11d2-b573-0000f87a546b
Last attempt @ 1999-05-03 18:07.09 was successful.

(Other data excluded because it does not pertain to this article.)

Under the Inbound Neighbors section of the output, the direct replication partners for each directory partition are identified along with the status of the last replication.

3.Find the directory partition that needs synchronization and locate the source server with which the target will be synchronized. Note the objectGuid of the source server.

4.Use Repadmin.exe to initiate replication by typing the following command:

repadmin /sync directory_partition target_server_name source_server_objectGuid

For example, to initiate replication on DC1 so that changes are replicated from DC2:

repadmin /sync dc=support,dc=microsoft,dc=com DC1 d2e3badd-e07a-11d2-b573-0000f87a546b

If successful, Repadmin.exe displays the following message:

ReplicaSync() from source: d2e3badd-e07a-11d2-b573-0000f87a546b, to dest: DC1 is successful.

Optionally, you can use the following switches on the command line:

•/force: Overrides the normal replication schedule.

•/async: Starts the replication event. Repadmin.exe does not wait for the replication event to finish.

•/full: Forces a full replication of all objects from the destination DSA.

 
Initiating Replication Using Active Directory Replication Monitor

1.On the Windows computer that will run the script, install the Windows Support Tools Resource Kit, which includes Active Directory Replication Monitor (Replmon.exe).

2.Start Active Directory Replication Monitor and click Add Site/Server on the Edit menu. Use the "Add Site or Server" Wizard to add the target server to the view.

3.Replmon.exe identifies the directory partitions and displays them as child nodes to the target server in the left pane.

4.Find and expand the directory partition that needs to be synchronized. All domain controllers listed for a given directory partition are source servers, but direct replication partners are displayed with an icon that represents two network-connected servers. Direct replication partners can also be identified by right-clicking a server and clicking Properties. The Properties dialog box displays the source server as a Direct Replication Partner, a Transitive Replication Partner, or a BridgeHead Connection (also a direct replication connection).

5.Right-click the direct replication partner, and then click Synchronize Replica. Replmon.exe initiates replication and reports the success or failure of the request.

  Fuente: http://support.microsoft.com/kb/232072

Cómo forzar la desinstalación de un domain controller

Cuando se desea forzar que un servidor ya no sea domain controller se debe seguir los pasos indicados en estos artículos de Microsoft

Dcpromo /forceremoval

 http://support.microsoft.com/kb/216498

http://technet2.microsoft.com/windowsserver/en/library/8eac646c-72bf-4f82-a656-c712b525ba561033.mspx?mfr=true

Cómo forzar la desinstalación de un domain controller

Cuando se desea forzar que un servidor ya no sea domain controller se debe seguir los pasos indicados en estos artículos de Microsoft

Dcpromo /forceremoval

 

 

http://support.microsoft.com/kb/216498

http://technet2.microsoft.com/windowsserver/en/library/8eac646c-72bf-4f82-a656-c712b525ba561033.mspx?mfr=true

Cómo transferir los roles de un Controlador de Dominio a otro

 

Algunas veces es necesario forzar la desinstalación de roles de un controlador de dominio, en este artículo de Microsoft se explica como (http://support.microsoft.com/kb/255504/es).

El administrador debe utilizar el Asistente de instalación de Active Directory para degradar correctamente un controlador de dominio contenedor de funciones. Este asistente reasigna las funciones contenidas localmente a un controlador de dominio existente del bosque. Las operaciones de degradación realizadas utilizando el comando dcpromo /forceremoval dejan las funciones FSMO en un estado no válido hasta que son reasignadas por un administrador.

 

Para transferir las funciones FSMO mediante la utilidad Ntdsutil, siga estos pasos:

1. Inicie una sesión en un equipo o controlador de dominio basado en Windows 2000 Server o Windows Server 2003 que esté ubicado en el bosque donde se están transfiriendo las funciones FSMO. Se recomienda que inicie una sesión en el controlador de dominio al que esté asignando las funciones FSMO. El usuario que ha iniciado la sesión debería ser miembro del grupo de administradores de organización para poder transferir las funciones de maestro de esquema o de maestro de nombres de dominio, o miembro del grupo de administradores de dominio del dominio donde se van a transferir las funciones de emulador de PDC, de maestro RID y de maestro de infraestructura.

2. Haga clic en Inicio y en Ejecutar, escriba ntdsutil en el cuadro Abrir y, a continuación, haga clic en Aceptar.

3.Escriba roles y presione ENTRAR.
Nota:
Para ver una lista de comandos disponibles en cualquiera de los símbolos del sistema de la utilidad Ntdsutil, escriba ? y, a continuación, presione ENTRAR.

4.Escriba connections y, a continuación, presione ENTRAR.

5.Escriba connect to server nombre del servidor y, a continuación, presione ENTRAR, donde nombre del servidor es el nombre del controlador de dominio al que desea asignar la función FSMO.

6.Escriba q en el símbolo del sistema server connections y, a continuación, presione ENTRAR.

7.Escriba transfer función, donde función es la función que desea transferir. Si desea consultar la lista de funciones que puede transferir, escriba ? en el símbolo del sistema fsmo maintenance y, a continuación, presione ENTRAR, o vea la lista de funciones incluidas al principio de este artículo. Por ejemplo, para transferir la función de maestro RID, escriba transfer rid master. La única excepción es para la función de emulador de PDC, cuya sintaxis es transfer pdc, no transfer pdc emulator.

8.Escriba q en el símbolo del sistema fsmo maintenance y, a continuación, presione ENTRAR para obtener acceso al símbolo del sistema de ntdsutil. Escriba q y, a continuación, presione ENTRAR para salir de la utilidad Ntdsutil.

 

Para asumir las funciones FSMO usando la utilidad Ntdsutil, siga estos pasos:

1.Inicie una sesión en un equipo o controlador de dominio basado en Windows 2000 Server o Windows Server 2003 que esté ubicado en el bosque donde se están asumiendo las funciones FSMO. Se recomienda que inicie una sesión en el controlador de dominio al que esté asignando las funciones FSMO. El usuario que ha iniciado la sesión debería ser miembro del grupo de administradores de organización para poder transferir las funciones de esquema o de maestro de nombres de dominio, o miembro del grupo de administradores de dominio del dominio donde se van a transferir las funciones de emulador de PDC, de maestro RID y de maestro de infraestructura.

2.Haga clic en Inicio y en Ejecutar, escriba ntdsutil en el cuadro Abrir y, a continuación, haga clic en Aceptar.

3.Escriba roles y presione ENTRAR.

4.Escriba connections y, a continuación, presione ENTRAR.

5.Escriba connect to server nombre del servidor y, a continuación, presione ENTRAR, donde nombre del servidor es el nombre del controlador de dominio al que desea asignar la función FSMO.

6.Escriba q en el símbolo del sistema server connections y, a continuación, presione ENTRAR.

7.Escriba seize función, donde función es la función que desea asumir. Si desea consultar la lista de funciones que puede asumir, escriba ? en el símbolo del sistema fsmo maintenance y, a continuación, presione ENTRAR, o vea la lista de funciones incluidas al principio de este artículo. Por ejemplo, para asumir la función de maestro RID, escriba seize rid master. La única excepción es para la función de emulador de PDC, cuya sintaxis es seize pdc, no seize pdc emulator.

8.Escriba q en el símbolo del sistema fsmo maintenance y, a continuación, presione ENTRAR para obtener acceso al símbolo del sistema de ntdsutil. Escriba q y, a continuación, presione ENTRAR para salir de la utilidad Ntdsutil.
Notas

•Bajo condiciones normales, las cinco funciones se deben asignar a controladores de dominio “activos” del bosque. Si un controlador de dominio que posee una función FSMO se lleva fuera de servicio antes de que se transfieran sus funciones, deberá asignar todas ellas a un controlador de dominio apropiado que esté en buenas condiciones. Se recomienda que solamente asuma todas las funciones cuando el otro controlador de dominio no vaya a regresar al dominio. Si es posible, repare el controlador de dominio dañado que tiene asignadas las funciones FSMO. Debería determinar qué funciones deben estar en cada uno de los controladores de dominio restantes con objeto de que las cinco funciones se asignen a un único controlador de dominio. Para obtener más información acerca de la ubicación de funciones FSMO, haga clic en el número de artículo siguiente para verlo en Microsoft Knowledge Base:

223346 (http://support.microsoft.com/kb/223346/) Ubicación y optimización del FSMO en controladores de dominio Windows 2000

•Si el controlador de dominio que anteriormente tenía funciones FSMO no está presente en el dominio y se han asumido sus funciones siguiendo los pasos descritos en este artículo, elimínelo del Active Directory realizando el procedimiento detallado en el siguiente artículo de Microsoft Knowledge Base:

216498 (http://support.microsoft.com/kb/216498/) Cómo quitar datos en Active Directory después de una degradación sin éxito de un controlador de dominio

•La eliminación de metadatos del controlador de dominio con la versión de Windows 2000 o de Windows Server 2003 build 3790 del comando ntdsutil /metadata cleanup no reubica las funciones FSMO asignadas a controladores de dominio activos. La versión de Windows Server 2003 Service Pack 1 (SP1) de la utilidad Ntdsutil automatiza esta tarea y elimina elementos adicionales de los metadatos del controlador de dominio.

•Algunos clientes prefieren no restaurar las copias de seguridad del estado del sistema de los titulares de las funciones FSMO en caso de que la función haya sido reasignada desde la realización de la copia de seguridad.

•No coloque la función de maestro de infraestructura en el mismo controlador de dominio que el servidor de catálogo global. Si el Maestro de infraestructura se ejecuta en un servidor de catálogo global no se actualizará la información de los objetos, pues no contiene referencias a objetos que no alberga. Esta situación se produce porque un servidor de catálogo global contiene una réplica parcial de cada objeto del bosque.

Herramientas para Sizing de SharePoint 2007

 

Determinar la cantidad y configuración necesaria para soportar servidores de SharePoint 2007 siempre ha sido una tarea difícil de enfrentar, muchas veces por falta de guías que permitar realizar esta labor de forma más clara. Afortunamente tanto Microsoft como HP tiene documentación y herramientas para hacer este sizing. En el caso de HP se cuenta con ActiveAnswers para Microsoft Office SharePoint Server que se puede bajar gratuitamente desde http://h20338.www2.hp.com/ActiveAnswers/cache/70675-0-0-0-121.html

En el caso de Microsoft existe documentación en el Technet para hacer dimensionamiento

Estimate performance and capacity requirements for portal collaboration environments disponible en http://technet2.microsoft.com/Office/en-us/library/054526b9-417e-4140-b251-79b68e771c9a1033.mspx?mfr=true

Plan for software boundaries (Office SharePoint Server) disponible en

http://technet2.microsoft.com/Office/en-us/library/6a13cd9f-4b44-40d6-85aa-c70a8e5c34fe1033.mspx?mfr=true

El siguiente es un ejemplo de los resultados de la herramienta de HP

image

Tuesday, January 29, 2008

Mensajería Unificada

Dentro de pronto en Costa Rica se hará el lanzamiento de productos de mensajería unificada de Costa Rica, para prepararte puede ir a http://www.microsoft.com/uc/default.mspx

Aumentar número de conexiones simultáneas en Internet Explorer

Para aumentar el número de downloads simultáneos en Internet Explorer vaya al registry a esta llave

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings

Cree un DWORD con el siguiente nombre

MaxConnectionsPer1_0Server

Modifique el valor por la cantidad de downloads simultáneos que prefiere.

Cree otro DWORD

MaxConnectionsPerServer

Modifique el valor por la cantidad de downloads simultáneos que prefiere.

Reinicie Internet Explorer

Monday, January 28, 2008

Mirroring en SharePoint 2007

Excelente artículo de Bill Baer

SQL Server 2005 Database Mirroring has increased in popularity since its introduction and among the possible applications there is a growing demand to implement SQL Server 2005 Database mirroring for SharePoint Products and Technologies. This article outlines the considerations and implications of designing SQL Server 2005 Database Mirroring into your SharePoint Products and Technologies database architecture.

Understanding Basic Database Mirroring Concepts

SQL Server 2005 Database Mirroring provides high-availability and rapid failover by continuously sending a databases's transaction logs from an originating SQL server instance (principal) to a destination SQL server instance (mirror). Since the granularity of failover is at the database level unlike the server level failover in Microsoft Cluster Server, SQL Server 2005 Database Mirroring failover can provide an increase in failover performance and is more seamless and transparent to the application. A complete overview of Database Mirroring in SQL Server 2005 is available at http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx.

Considerations and Implications

There are several important factors to consider before implementing SQL Server 2005 Database Mirroring in your SharePoint Products and Technologies infrastructure. Prior to implementing SQL Server 2005 Database Mirroring, you should understand what problems you are trying to solve whether they are performance, availability, or geographic replication related.

Determine the SQL Server 2005 Database Mirroring implementation mode - High Performance vs. High Availability vs. High Protection
High performance SQL Server 2005 Database Mirroring is also known as asynchronous mirroring where the transaction safety level is OFF. In high performance mirroring the transaction is committed as soon as the principal server writes the log record to the local log and sends the log record to the mirror. The principal does not wait for acknowledge and if needed queues the logs, a failover at this point may result in data loss.
High availability SQL Server 2005 Database Mirroring is also known as synchronous mirroring where the transaction safety level is FULL. Each transaction committed on the principal database is also committed on the mirror server synchronously. The principal server will only commit a transaction after receiving acknowledgement from the mirror server indicating the transaction log has been hardened. This process of acknowledgement and receipt results in slower performance versus asynchronous mirroring.
High protection SQL Server 2005 Database Mirroring is also known as synchronous mirroring where the transaction safety level is FULL and is similar to high availability with primary difference being that there is no implementation of a witness server which requires manual failover.
SQL Server 2005 Standard Edition allows only the FULL transaction safety level.
Understand and plan for database limitations
master, model, temp, or msdb cannot be mirrored.
SQL Server 2005 Database Mirroring requires that the databases use the FULL recovery model, the SIMPLE and BULK-logged recovery models cannot be used.
Transactions are played out on two servers, limiting the number of databases will reduce the performance cost.
Fewer databases will result in less overhead, by limiting the number of databases in a mirroring session you can maintain optimum performance levels. This may require the repartioning of smaller content databases to achieve fewer and larger content databases. Larger databases can leverage multiple data files spanning one or more drives to optimize performance and management.
Mirror databases that require redundancy and/or high value databases - content databases typically fall into this category.
Determine the appropriate hardware requirements - Can a single SQL server support your infrastructure?
Automatic failover requires a witness (polling) server. The witness server's role is to enable automatic failover - if the mirror server has confirmation from the witness, it can automatically take on the role of principal and make its database available.
SQL Server 2005 Database Mirroring requires two unique SQL server instances, one on the principal server and one on the mirror server.
Determine the deployment methodology
Decide on a localized or geographically disperse deployment. A geographically disperse deployment provides a disaster solution, but comes with performance implications as the result of network performance, latency, and type LAN vs. MAN vs. WAN.
Security
SQL Server 2005 Database Mirroring supports both Windows (NTLM/Kerberos) and Certificate based SQL authentication.
SQL Server Database Mirroring supports both AES and RC4 encryption algorithms for transmission encryption.
Decide on shared vs. dedicated storage
Storage is duplicated in mirroring 1TB of storage on the principal server requires 1TB of storage on the mirror server. Since each server in a mirroring partnership is a unique SQL server instance, the resources are not shared.
Plan for capacity
SQL Server 2005 Database Mirroring requires duplication of storage, before designing mirroring into your database architecture you should understand the capacity requirements of the current server farm and future scale. 1TB of storage on an MSCS cluster with shared storage requires 2TB of storage in mirroring, 1TB on the principal and 1TB on the mirror.
Change - understand the existing SharePoint Products and Technologies infrastructure's rate of change (churn). The performance of the principal server is affected by the transfer of log records to the mirror.
Long running and/or intensive transactions can impact performance and failover times and can include creating and/or rebuilding an index on a large table or bulk loading a large amount of data (Search).
Log bound workload performance under database mirroring is highly dependent on network performance and log I/O.
Handling role changes - understand the implications resulting of the loss of the principal or mirror server on SharePoint Products and Technologies.
Understand the manual failover steps to support SharePoint Products and Technologies.
Script an automatic failover mechanism to handle client-redirects.
Managing failover - SQL Server 2005 Database Mirroring works with a single database at a time. You need to take this into account when designing SQL Server 2005 Database Mirroring into your database architecture. *See Failover Handling
Planning and implementation
To provide the best initial performance when implementing SQL Server 2005 Database Mirroring, consider taking an online backup of the principal database(s), copy the database(s) to the mirror server and restore the database(s) with the option to apply further transaction logs. This will reduce the length of time associated with initial synchronization and minimize the performance implications of the initial synchronization.
Ensure the implication of mirroring role changes is understood and planned for and the technology has been thoroughly tested before designing into your database architecture.
A one to one mapping of principal to mirror server is recommended to maximize compatibility with SharePoint Products and Technologies.
In high availability SQL Server 2005 Database Mirroring the process of determining a failover is based on the network connection. If there is a problem with the network, mirroring will fail over or deny access to the database because of the quorum requirement. Understand the network implications on database mirroring.
As with any product or technology understand the support parameters, limitations of the product or technology, and ensure it has been thoroughly tested prior to a production implementation.
Failover Handling

The introduction of a witness server in your SQL Server 2005 Database Mirroring architecture provides a mechanism for automatic failover; however, since mirroring granularity is at the database level, it is important to consider how to handle both single, multiple database and/or server failure. Since the principal and mirror server SQL server instances are unique, SharePoint Products and Technologies will need to be made aware of the database server hosting its content. The following sections details the STSADM operations that can be run to create this awareness in Windows SharePoint Services 3.0/Microsoft Office SharePoint Server 2007.

If an individual database fails you can set the database server using the SharePoint 3.0 Central Administration user interface or STSADM.

Content Database Failover

To change the principal server for a content database using STSADM run:

stsadm -o deletecontentdb -url "" -databasename "" -databaseserver ""
stsadm -o addcontentdb -url "" -databasename " " -databaseserver ""
To change the principal server for a content database using the SharePoint 3.0 Central Administration user interface:

In SharePoint 3.0 Central Administration select Application Management, then click Content Databases.
From the Manage Content Databases page, select Remove content database for the failed content database.
From the Manage Content Databases page, select Add a content database to reinstate the content database on the new principal server.
Configuration Database and Administration Content Database Failover

The configuration and administration content database must reside on the same SQL database server, in the event that either of these databases fails, both must be failed over to the new database server. To failover the configuration and administration content database, run the following STSADM from a web front-end computer:

stsadm.exe -o renameserver -oldservername -newservername
Restart Internet Information Services to commit the change.

Search Database Failover

The following STSADM operation should be run from one web front-end computer for each failed search database.

stsadm –o editssp –title –ssplogin –ssppassword -searchdatabaseserver
Shared Services Database Failover

The following STSADM operation should be run from one web front-end computer for each failed SSP database.

stsadm –o editssp –title –ssplogin –ssppassword -sspdatabaseserver

The information provided above details the steps necessary to instantiate a manual failover of the various components of a SharePoint Products and Technologies server farm, for additional information on scripting automatic client-side redirect in the event of failover see Alerting on Database Mirroring Events and Database Mirroring in SQL Server 2005 under Resources and Recommended Reading. While it is possible to mirror the configuration and other databases associated with a SharePoint Products and Technologies server farm through the proper implementation of STSADM operations; support of SQL Server 2005 Database Mirroring for SharePoint Products and Technologies is limited to the content databases.

Basic SQL Server 2005 Database Mirroring Implementation for SharePoint Products and Technologies

The most common implementation of SQL Server 2005 Database Mirroring includes all databases being installed on a single mirror partnership and the implementation of a witness (polling) server that provides automatic database failover between the principal and mirror servers when necessary. A witness server additionally provides quorum capabilities for a mirroring partnership; as a result in the event a principal server is lost, the witness will bring the mirror server online.

The witness server does not serve as a content host nor perform intensive operations and as a result can be safely implemented on an application server in a SharePoint server farm in most circumstances.

After installing and configuring SQL Server 2005 you should test the communication channels between each server machine by confirming DNS name resolution and ensuring the latency between each node is within an acceptable parameter.

Database Selection and Preparation

To begin a database mirroring session you should identify the databases that will be mirrored. To maximize availability and reduce any potential issues during failover, it is recommended to mirror each database within a SharePoint Products and Technologies deployment. In a database mirroring partnership SQL Server allocates memory to each database mirroring connection, to avoid potential performance implications you should consider a database capacity that can support your environment and additionally host content in a minimum count of content databases. See Database Management Concepts for Large and Growing Content Databases for more information on capacity planning and design for content databases.

Set the Database Recovery Model to FULL on all Databases

On the SQL Server 2005 Principal server, click Start, All Programs, Microsoft SQL Server 2005, and then click SQL Server Management Studio.

Expand the Databases and System Databases node.

Right-click master and select New Query from the menu.

In the rightmost panel, enter the following SQL statement:

ALTER Database
SET RECOVERY FULL;

Select Query, and then click Execute from the SQL Server Management Studio toolbar.

The results of the operation will be displayed in the rightmost Results panel.

Backup SharePoint Products and Technologies Databases

On the SQL Server 2005 Principal server, click Start, All Programs, Microsoft SQL Server 2005, and then click SQL Server Management Studio.

Expand the Databases and System Databases node.

Right-click master and select New Query from the menu.

In the rightmost panel, enter the following SQL statement:

BACKUP Database
TO DISK = <'backuppath'>
WITH Format
Go

Select Query, and then click Execute from the SQL Server Management Studio toolbar.

The results of the operation will be displayed in the rightmost Results panel.

Restore the SharePoint Products and Technologies Databases to the Mirror Server

On the SQL Server 2005 Mirror server, click Start, All Programs, Microsoft SQL Server 2005, and then click SQL Server Management Studio.

Expand the Databases and System Databases node.

Right-click master and select New Query from the menu.

In the rightmost panel, enter the following SQL statement:

RESTORE Database
FROM DISK = <'restorepath'>
WITH NORECOVERY
Go

Select Query, and then click Execute from the SQL Server Management Studio toolbar.

The results of the operation will be displayed in the rightmost Results panel.

Backup Transaction Logs on the Principal Server

On the SQL Server 2005 Principal server, click Start, All Programs, Microsoft SQL Server 2005, and then click SQL Server Management Studio.

Expand the Databases and System Databases node.

Right-click master and select New Query from the menu.

In the rightmost panel, enter the following SQL statement:

BACKUP LOG
TO DISK = <'backuppath'>
WITH Format
Go

Select Query, and then click Execute from the SQL Server Management Studio toolbar.

The results of the operation will be displayed in the rightmost Results panel.

Restore Transaction Logs to Mirror Server

On the SQL Server 2005 Mirror server, click Start, All Programs, Microsoft SQL Server 2005, and then click SQL Server Management Studio.

Expand the Databases and System Databases node.

Right-click master and select New Query from the menu.

In the rightmost panel, enter the following SQL statement:

RESTORE LOG
FROM DISK = <'restorepath'>
WITH FILE=1, NORECOVERY
Go

Select Query, and then click Execute from the SQL Server Management Studio toolbar.

The results of the operation will be displayed in the rightmost Results panel.

Configure Database Mirroring Connections

On the Principal server click Start, All Programs, Microsoft SQL Server 2005, and then click SQL Server Management Studio.
Expand the Databases node.
Right-click the database to mirrored and select Properties from the menu.
On the Database Properties - dialog, select Mirroring under the Select a page panel, and then click Configure Security.
Click Next> on the Configure Database Mirroring Security Wizard or click Cancel to quit.
On the Include Witness Server dialog, if a witness server will be configured (recommended), click Yes otherwise click No, and then click Yes to continue or < Back to return to the previous screen.
On the Choose Servers to Configure dialog select Principal server instance, Mirror server instance, and Witness server instance, and then click Next > to continue.
On the Principal Server Instance dialog select the Principal server instance from the menu, configure the Listener port to 14999 and specify EndPoint_Mirroring in the Endpoint name field, select Encrypt data sent through this endpoint, and then click Next > to continue or < Back to return to the previous screen.
On the Mirror Server Instance dialog select the Mirror server instance from the menu and click Connect...
Configure the Listener port to 14999 and specify EndPoint_Mirroring in the Endpoint name field, select Encrypt data sent through this endpoint, and then click Next > to continue or < Back to return to the previous screen.
On the Service Accounts dialog review and confirm the settings, and then click Next > to continue or < Back to return to the previous screen.
Click Finish to close the Configure Database Mirroring Security Wizard.
On the Configuring Endpoints dialog ensure all actions are Successful; otherwise, return to the Configure Database Mirroring Security Wizard and resolve any conflicts or when all actions are Successful click Close.
Confirm High safety with automatic failover (synchronous) - Always commit changes at both the principal and mirror is selected under Operating mode and then select Start Mirroring to initialize database mirroring for the selected database.
Click Refresh and confirm the Status is indicated as Synchronized: the databases are fully synchronized. If there are any conflicts the Status will be commonly indicated as This database has not been configured for mirroring.
Click OK to close the Configure Database Mirroring Security Wizard.
Repeat steps 1 - 16 for each database to be mirrored.

Post Implementation Review and Testing

To confirm the mirroring connection has been configured successfully confirm the principal server database(s) is indicated as Principal, Synchronized, and the mirror server database(s) is indicated as Mirror, Synchronized / Restoring.
To test failover restart the MSSQLSERVER service.
Database mirroring is increasing in popularity and becoming an integral part of high availability and disaster recovery solutions within the SharePoint Products and Technologies arena. I've spent much of the last few months building labs, testing scenarios, impacts on platforms whether it be WSS or MOSS. This post is the third and final on my series [SQL Server 2005 Database Mirroring and Windows SharePoint Services/Microsoft Office SharePoint Server 2007].

We know with asynchronous mirroring we can automatically manage SQL Server 2005 failover by introducing the witness role in our server farms, the most challenging question to answer is how to manage web front-end failover. In this post I will outline several possible solutions for managing SharePoint Products and Technologies failover in a mirrored database architecture.

Solution # 1 Network Load Balancing

In a high-availability environment, you can create a NLB cluster to easily route client requests from the original principal server to a promoted mirror server without having to update each client directly. NLB setup and configuration are fairly painless; however, it comes with the requirement that each server be on the same subnet and the active mirror remain in a suspended state in the load balancing rotation. With this in mind you should carefully consider the limitations when using native NLB, for example you will not be able to geo-cluster in most circumstances.

Solution # 2 Manual Failover

Manual failover requires the least in respect to infrastructure and configuration; however, has the highest operational costs and without proper management and monitoring can present the largest client impact in the event the of a failover. The steps required to instantiate a manual failover of SharePoint Products and Technologies are described in the first part of this series.

Solution #3 Custom Solutions (Example)

Custom solutions can be implemented monitoring the state of the principal and mirror servers redirecting the application calling the original principal server to the new principal server - typically implemented through a Windows service.

For example, using an aliasing scheme where SharePoint Products and Technologies accesses the SQL database server through an alternate name; SharePoint Products and Technologies accessing the alternate name is redirected to the proper physical name of the principal server. Since SharePoint Products and Technologies is only aware of the alternate name and never accesses the physical name of either node it does not need to be failover aware.

From a logical perspective in the example solution proposed SharePoint Products and Technologies would make the request to the SQL alias, for example contoso, requests for contoso are intercepted and modified to reference the active principal node referenced in the web front-end server Registry as contoso1. In a failover scenario, the Windows service would detect the principal role is on the new principal server, previously the mirror server, and replace the web front-end server Registry entry for contoso1 with the new principal physical server contoso2.

Respaldos de Team System Team Fundation Source Control

El siguiente script te ayuda a crear un respaldo por línea de comandos del código contenido en Team Foundation Server Source Control

"C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\tf.exe" get /recursive /overwrite
for /F "tokens=2-4 delims=/ " %%v in ('date /T') do (
set month=%%v
set day=%%w
set year=%%x)
"c:\Program Files\WinRAR\rar.exe" a TFS_BAK WORKSPACE_NAME s
ren "C:\Backup\TFS_BAK.RAR" "CUMULUS_%year%%month%%day%.RAR"

Backups de SharePoint por linea de comandos

Algunas veces es necesario crear backups de Sharepoint por linea de comandos, a continuación encontras un script muy util para hacerlo:


echo =====================================
echo Backup Script For SharePoint
echo =====================================
@SET SPDIR="c:\program files\common files\microsoft shared\web server extensions\60
@echo on
%SPDIR%\bin\stsadm" -o backup -url http://tfs/sites/MySite -filename "D:\Backup\WssBak.dat" -overwrite
@echo on
for /F "tokens=2-4 delims=/ " %%v in ('date /T') do (
set month=%%v
set day=%%w
set year=%%x)
ren "D:\Backup\WssBak.dat" "WssBak%year%%month%%day%.dat"
xcopy "D:\Backup\WssBak%year%%month%%day%.dat" \\server\shared /Y
echo completed

Primero hace un backup del sitio a un archivo, y luego lo renombra de esta forma podras crear un backup diario sin sobreescribir los anteriores.

Saturday, January 26, 2008

Comunidad de usuarios de Windows Costa Rica

Les informo que existe una nueva comunidad de usuarios de Windows en Costa Rica, para más detalles ingresa en http://mswindowscr.org

Lanzamiento de productos 2008

A principios de marzo de este año será el lanzamiento oficial de los productos 2008 en Costa Rica, no te pierdas este gran evento donde podrás todos los nuevos adelantos de Windows.

Thursday, January 17, 2008

Restaurar objetos borrados en Active Directory

Si tienes que recuperar objetos del Active Directory puedes usar esta herramienta

http://www.quest.com/object-restore-for-active-directory/

Object Restore for Active Directory

Recovering Deleted Objects in Active Directory
Restoring deleted objects and information in Active Directory can be a manual and time-consuming task. Native backup and recovery utilities require intense involvement by the administrator, knowledge of what objects were deleted or affected, and require a Domain Controller to be rebooted. As a result, it is difficult for organizations to meet reasonable service levels for restoring deleted information in Active Directory, and avoid recovery pitfalls such as lost productivity and system downtime.


Object Restore for Active Directory Freeware
Restoring single, deleted objects in Active Directory can be a manual and time-consuming process requiring system downtime. Object Restore for Active Directory is a free, graphical utility that allows you to instantly recover deleted objects in a Windows Server 2003 environment without rebooting a Domain Controller. The freeware utility allows viewing Tombstoned objects in Active Directory and reanimating deleted items using Microsoft’s new Tombstone Reanimation interfaces for Windows Server 2003. When you download the Freeware, a 6-month key is built in. You will be prompted to re-register on our site at the end of each 6-month period.

Recovery Manager for Active Directory
Quest Software’s enterprise Active Directory recovery solution provides all the functionality an administrator needs to ensure their Active Directory is properly backed up, and that deleted Active Directory objects and data and Group Policy can be quickly recovered in the event of corruption or inadvertent modification due to hardware/software failures or human error. Download or upgrade to Recovery Manager for Active Directory.

Please Note: Object Restore for Active Directory is unsupported freeware. The license key expires at the end of 6 months. To renew, you must uninstall the product and reinstall.

SQL Server 2016 Stretch Databases

El SQL Server Stretch Database permite que los datos históricos o de bitácoras puedan ser movidos hacia Azure, específicamente permite mover...