|
||||||
|
Similar to my Windows 2008 clustering adventures, I recently went through some problems when trying to cluster SQL 2008 on Windows 2008 R2. Long story short, you have to install SP1 prior to installing SQL or simply slipstream the install. The install blew up on: There was an error setting private property ‘RequireKerberos’ to value ‘1′ [...] Experienced a rather odd problem today … I scripted out multiple jobs from a SQL2000 environment using SSMS 2008 that call DTS packages. The command line for the jobs looked like DTSRUN /S “Server\Instance” /N “PackageName” /E. When I ran the jobs, they continually returned: The GROUP BY CUBE statement is pretty sweet. Here’s an example. First, let’s create our table and add data: IF EXISTS (SELECT * FROM sys.objects CREATE TABLE [dbo].[GroupByCubeExample]( INSERT INTO dbo.GroupByCubeExample Management Studio 2008 has a default that prevents saving table changes from the designer when the table will need to be rebuilt. I’m constantly being asked about this error by developers: ”Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.” To be able to make table changes [...] Locally I am running 2008 R2 and on my DBA management server I run 2008 RTM. Today I went to restore a database from my local to my server and received the following awesome error: The database was backed up on a server running version 10.50.1092. That version is incompatible with this server, which is [...] I have been a DBA for about 5 years and unfortunately have not had any experience with clustering. That was up until I was hired by my current employer back in January and since have brought up several 2005 clusters and now manage over 12 clusters. I have installed, setup and configured many 2008 instances [...] |
||||||
|
Copyright © 2010 SQL Slayer - All Rights Reserved |
||||||
Comments