Tag Archives: SQL Server 2008

Using Multiple Physical NICs in Hyper-V

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

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

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

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

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

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 , , , , | 1 Comment

SQL Failover Cluster – Part 1

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

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

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

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