Category: SQL

Extending a shared virtual disk into multiple VMs

I leave you this post because a client has asked me to do it on several occasions and so I leave it for you 😉 too If we need to expand a virtual hard drive (Vhd) that is shared across multiple virtual machines, typically for cluster use, we will remember that we have the SCSI controller in Bus Sharing and that the disk is created in Eager Zeroed! We will follow these steps to expand this album.

XenDesktop – SQL Mirroring with Witness

I'm Oscar Mas and I want to show you how to implement a Mirror system with Witness based on Microsoft SQL Server, which is a perfect and recommended example to have our XenDesktop database in high availability. In this way we will be able to have a mirror with Microsoft SQL failover.

Microsoft Security Compliance Manager – Hardening our servers

Microsoft Security Compliance Manager 2 is a repository of Microsoft security templates that we can apply to our servers or PCs on our network providing greater security, since these templates are predefined depending on the OS. and the services run by the target machine. The good thing is that we will be able to keep the templates always 'up to date’ through updates that we can download from the console. We will be able to import GPOs, More Baselines… we will be able to edit/duplicate them and to apply them to our environment we will export them.

Installing SQL Server 2008 in Windows cluster 2008 R2

In this document, we'll look at installing a SQL Server cluster 2008 under two Windows Server nodes 2008 R2, we will install both nodes to obtain a SQL Server service in high availability. First of all, you have your Windows cluster 2008 R2 mounted and well configured, to which we will have several disks available for the databases, Logs, backup and MSTDC (We can rely on to create the cluster: HTTP://www.bujarra.com/?p=2290).

SQL Server Scheduled Database Backup 2005

Let's perform a scheduled backup of a SQL Server Database 2005 if you do not have any centralized backup system. We must keep in mind that this system is not going to replace the backups that are constantly being generated, therefore we have to look at or look for a solution so that it does not increase too much and fill up the disk.

Replicating SQL Server databases 2000

This procedure explains how to replicate a SQL Server database from one server to another continuously. Used in the case of having an online backup of the server in case of a crash; and users can work against the other server without making much change (for example with a simple change of alias in the DNS's).