10/9/10

Good Links about SQL

hi

We had problems with SQL 2005 and Cluster SQL 2005.

Take a look.

http://technet.microsoft.com/en-us/library/ms144259(SQL.90).aspx

http://support.microsoft.com/kb/953200/en-us

 

Yes, Yes, there are many links about that, but we used it them.

regards

sAnTos

Visio Stencis for Hyper-V

Hi

I colleague send me this link:

http://www.jonathancusson.com/tag/virtualization-stencil/

image

Thanks Marta

 

sAnTos

Merge Hyper-V files. Merging .avhd and .vhd files

Hello

We had a big VM

image

I remove applications and Hyper-V did the merging process with all files by itself.

Good

image

sAnTos

VDI, Hyper-V R2 with CSV, VMMR2 and strange things

Hi

We have Citrix XenDeskTop 4 and VDI with Hyper-V R2.

We have some VDI with CSV. We removed a VDI from the cluster.

The VMMR2 and Citrix had a problem. The hyper-V R2 didt remove the machine well and I can see the VM in both nodes. So Citrix show me 2 VM (the same VM) in the Citrix Menu. So We had a problem.

Citrix XenDesktop – hype-V R2. FOr example We had 2 wxp377CARTV in this menu.

image

 

The XenDesktop 4 read data from VMMR2. And We had problems. Look the pictures

image

 

image

So, I spent some time refreshing data, deleting old machines, rebooting and finally, I had a clean VMMR2. So the problems were fixed.

image

sAnTos

SharePoint, ans Suspect SQL Database

Hi

I have a SharePoint Foundation 2010

The Share_Admin DDBB was in suspect mode.

We did:

image

image

ALTER DATABASE SharePoint_Config SET EMERGENCY
GO
ALTER DATABASE SharePoint_Config SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
GO
DBCC CHECKDB (SharePoint_Config, REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE SharePoint_Config SET MULTI_USER
GO

Now , we cand admin the SPF 2010 without problems.

Everthing goes well

Thank to Guille

(spanish links, sure there are many more in English)

http://www.guillesql.es/Articulos/Base_Datos_Sospechosa_Suspect_SQL_Server_2005.aspx

http://www.guillesql.es/Articulos/SQLServerFAQ_Base_Datos_Suspect_Sospechosa_sp_resetstatus_DBCC_DBRECOVER_Emergency_Mode.aspx

sAntos