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 add a node to an existing SQL Server…


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, you could follow the way below…


Logshipping secondary server is out of sync and LSRestore job failing

Logshipping secondary server is out of sync and transaction log restore job failing. ProblemYou can see that your logshipping is broken. In the SQL Error log,  the message below is displayed : Error: 14421, Severity: 16, State: 1.The log shipping secondary database myDB.logshippingPrimary has restore threshold of 45 minutes and is out of sync. No…


Disaster Recovery Plan using Microsoft SQL Server Logshipping

Disaster Recovery Plan using Microsoft SQL Server LogshippingThe 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 regular transaction logs of a…


Migration SQL Server 2000 to SQL Server 2008

The purpose of this post is to explain the minimum required for the migration of Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You can use the same principles to migrate a Microsoft SQL Server 2005 to Microsoft SQL Server 2008. 1. SQL server 2008 upgrade advisor1.1. Before migratingMicrosoft provides a tool called “Microsoft…

6

Migration SQL Server 2000 DTS to SSIS 2005/2008

Migration DTS packages to SSIS 2005/2008Setup SSIS with DTS 2000On the migration of 2000 DTS to SSIS 2005/2008. There are many known issues in the migration of DTS 2000. It is recommended to execute the DTS inside SSIS 2005/2008 without migration. And if you need to edit a DTS in 2000 it will be better…


SSMS 2005 on IA64 shuts down suddenly after clicking on "New Query"

SQL Server Management Studio 2005 on IA64 shuts down Problem descriptionSQL Server Management Studio 2005 on IA64 crashs when you click on “New Query” button. It shuts down Management Studio automatically. This issue arrive when you are on Windows 20003 IA64 and SQL Server 2005 IA 64Another symptom is that when you attach the debugger…


Which Service Pack do I have to install on SQL Server ?

The model of delivery patch for Microsoft SQL server follows a very precise process that is described in the following article : http://support.microsoft.com/kb/935897/  We always recommend applying the latest Service Pack (SP) for SQL. However, you should apply it only after validation on your test platform. – How to obtain the latest service pack for SQL…

1

Configuring SSIS

Configure SSIS When you want to use SSIS with a named instance or cluster or remote, you must configure the SSIS service in accordance with the recommendations of the article below: Configuring the Integration Services Servicehttp://msdn2.microsoft.com/en-us/library/ms137789.aspx  To avoid problems related to the ambiguity of names msdb, you must also change the names of the tag…

1

Welcome to SQL Server ryders

Hello all,My name is Michel Degremont. I’m Technical Specialist on SQL Server since 4 years @ Microsoft EMEA. I’ve just created this blog to share with you various experience and question that I am meeting regularly.In this blog, I will talk about Microsoft SQL Server Core , Reporting Services, Analysis Services, Replication, Clustering and playing…