For Spanish version visit this link Error instalando Nodo de Cluster SQL Server 2008 R2This week, we are migrating the Production servers to SQL Server 2008 R2 SP1. During the installation of a Node of SQL Server Cluster, the following error occured:Error reading from file: X:\PATHFOLDER\x64\setup\sql_engine_core_inst_msi\PFiles\SqlServr\MSSQL.X\MSSQL\Binn\Template\master.mdfVerify that the file exists and that you can access it.After doing several tests, we saw that we couldn’t copy files with .mdf, .ndf, .ldf and .bak extensions to C:\ drive, we start to check the users permissions, policies, file permissions and it not worked, so after 3 hours we decided to stop. The next day a co-worker said that could be the antivirus, we disabled it and the installation works like a charm.This is an example of how an small unexpected failure calculation can make you to pass a hard time. One thing is sure, from now on at the minimum strange error, the first that I will probe is to disable the antivirus.

For Spanish version visit this link ¿Qué he aprendido en el último año? Recursos y webs que te ayudarán a comenzar con SQL ServerWithin days, June 20th, will be one year since I joined Avanade Spain, so I think that is a good moment to stop and think over all learned in the last 366 days.I can safely say that this was the year that I’ve grown more as SQL Server professional, When I started at company, didn’t know practicaly how a cluster works; the replication seemed a world apart; I wasn’t familiar with SQL Scripting; and my English level was much worse (you can see how badly I write, but before was even worse).I got my new knowledges in a big part thanks to my father, my co-workers, Google, MSDN forums, and blogs that saved my life a lot of times, I going to enumerate some of this:Read more of this post

For Spanish version visit this link Scripts: Jobs no ejecutados en el último año / Actividad de Jobs DetalladaA few days ago i was looking for a script to let me know when was the last execution of a job, so I can review the jobs that were not executed in the last year and delete the ones not needed, but i couldn’t find anything valid, so i had to create one. I use the columns last_run_date and last_run_time from sysjobservers table to get this value, the scripts that i found on Internet used other columns from other tables which i will describe why i not chose:Read more of this post

For Spanish version visit this link El proceso de mezcla no pudo crear una nueva generación en ‘Publisher’Yesterday we did an massive update of 1 million of registers in a table of the replication DB, after the update , we started the replication of one computer, and we saw a failure in the first publication after 2000 seconds, showing the next error:“The merge process was unable to create a new generation at the ‘Publisher’. Troubleshoot by restarting the synchronization with verbose history logging and specify an output file to which to write.”Read more of this post