Tag Archives: SQL Server 2008

Using Multiple Physical NICs in Hyper-V

Posted on June 16, 2014 by John

I have a lab environment that I use to “try before implementing “things” Microsoft. The lab is hosted on a PC running Windows Server 2008 R2 with Hyper-V. The physical Hyper-V server may host at least 4 guest Windows servers … Continue reading →

Posted in General Information, Lab Projects | Tagged , , , , , | Leave a comment

System Center DPM Application Backup-Restore – SQL

Posted on May 3, 2013 by John

This blog post shows how to use Microsoft System Center Data Protection Manager (DPM) to backup databases on a Windows 2008 R2 server running SQL Server2008R2. System Center DPM has the ability to backup and restore data files on direct … Continue reading →

Posted in Lab Projects, Tips | Tagged , , , , | 1 Comment

Veeam Backup & Replication

Posted on April 21, 2013 by John

I recently had an opportunity to participate in another backup solution. This project used Veeam Backup & Replication and the VeeamOne Management Suite. You can get product information, whitepapers, technical references, videos and the inevitable marketing pitches and testimonials on the … Continue reading →

Posted in Products, Tips | Tagged , , , , , , | Leave a comment

SQL Failover Cluster – Part 4

Posted on August 19, 2011 by John

Continuing on from Part 3 of this series on SQL Server Failover Clustering, the next step after Creating the Distributed Transaction Coordinator (DTC) Service on the failover cluster is to Create the SQL Server instances on each participating node. This … Continue reading →

Posted in Lab Projects, Service, Tips | Tagged , , | 2 Comments

SQL Failover Cluster – Part 3

Posted on August 19, 2011 by John

As mentioned in Part 2 of this series on SQL Server Failover Clustering, the next step after Creating the Windows Failover Cluster is to Create the Microsoft Data Transaction Coordinator (MSDTC) Service. This post will present the detailed steps that … Continue reading →

Posted in Lab Projects, Service, Tips | Tagged , , | 1 Comment

SQL Failover Cluster – Part 2

Posted on August 17, 2011 by John

As mentioned in Part 1 of this series on SQL Server Failover Clustering, the next step after Creating the SAN Target is to Create the Windows Failover Cluster. This subject has been covered in Windows Failover Clustering http://level7techgroup.com/blog/?p=406, so this … Continue reading →

Posted in Lab Projects, Service, Tips | Tagged , , , , | 2 Comments

SQL Failover Cluster – Part 1

Posted on August 17, 2011 by John

SQL Server 2008 R2 supports two High Availability features: Database Mirroring and Failover Clustering. Database Mirroring has been covered in a previous post, SQL Server 2008 Database Mirroring. This blog post will cover the creation of a SQL Server Failover … Continue reading →

Posted in Lab Projects, Service, Tips | Tagged , , , , , | 1 Comment

SQL Server 2008 Database Mirroring

Posted on August 8, 2011 by John

This post is going to cover SQL Server Mirroring. SQL Server 2005 will support mirroring, but it’s best to have SQL Server 2008 or SQL Server 2008 R2 Enterprise installed on your servers. The Level 7 Tech Group lab is … Continue reading →

Posted in Lab Projects, Reviews, Tips | Tagged , , , , , , , | 6 Comments

Windows Failover Clustering

Posted on July 29, 2011 by John

As a Business Intelligence (BI) Build Engineerworking in Microsoft IT Services, I was brushing up on SQL Server 2008 High Availability options when I found two books on the subject in the Microsoft Library on the subject and checked them … Continue reading →

Posted in General Information, Products, Reviews, Tips | Tagged , , , , , , , , | 2 Comments

Microsoft Dynamics CRM 4.0

Posted on March 10, 2011 by John

This particular exercise happened over a year ago. Nevertheless, I thought it might make a good read and so, here it is. The Level 7 Technology Group was considering a move to the Chicago area during the summer. In December … Continue reading →

Posted in Reviews | Tagged , , , , , | 2 Comments