SQL SERVER BACKUP LOG WITH Truncate_only

 

La opción WITH TRUNCATE_ONLY ya no está soportada en SQL Server 2008, para liberar el espacio del LOG tienes que hacer un respaldo FULL o cambiar el modo de recuperación temporalmente a SIMPLE. Después de realizar esto debes hacer un Shrink del archivo LOG lo puede hacer desde el Management Studio o por medio de script.

El siguiente es un ejemplo de lo que no está soportado en SQL 2008

BACKUP LOG Test with Truncate_only
‘Truncate_Only’ is not a recognized BACKUP option.

Para hacer el Shrink puedes pobrar

 

dbcc shrinkfile ([DBName])

 

Saludos,

Eduardo Castro – Microsoft SQL Server MVP

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

 

ea8yscquj6

ea8yscquj6

 

SQL 2008 Error al restaurar la bd MSDB de una instancia a otra

Si haces un respaldo de la base de datos MSDB y la recuperas en otra instancia puede que se presente este error cuando alguien con pocos privilegios intenta ver los paquetes de jobs en el Management Studio

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The EXECUTE permission was denied on the object ‘xp_sqlagent_enum_jobs’, database ‘mssqlsystemresource’, schema ’sys’. (Microsoft SQL Server, Error: 229)

 

Para solucionarlo MS recomienda ejecutar el siguiente script

use msdb
go
– Backup the Agent certificate from the remote server to a file
BACKUP CERTIFICATE [##MS_AgentSigningCertificate##] TO FILE = ‘MS_AgentSigningCertificate.remote_server.cer’
go
use master
go
– re-create the agent certificate on master
– Note: Because we are making these changes using a regular user and not as part of setup, the name
– cannot include the ## token.
– Creating a regular certificate in this case should be the equivalent as we only need it to derive a SID

CREATE CERTIFICATE [MS_AgentSigningCertificate.remote_server] FROM FILE = ‘MS_AgentSigningCertificate.remote_server.cer’
go
– Recreate the user mapped to the cert and grant the same permissions that the regular certificate needs.
CREATE USER [MS_AgentSigningCertificate.remote_server] FROM CERTIFICATE [MS_AgentSigningCertificate.remote_server]
go
GRANT EXECUTE TO [MS_AgentSigningCertificate.remote_server]
go

http://support.microsoft.com/default.aspx?scid=kb;en-us;2000274&sd=rss&spid=13165

Saludos,

Eduardo Castro – Microsoft SQL Server MVP

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

 

Cambios de una tabla con el Management Studio de SQL 2008 no se pueden guardar

En SQL Server 2008 Management Studio puede ser que presente el siguiente error cuando se intenta guardar los cambios realizados a una tabla por medio del diseñador o editor gráfico.

Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created

Esta es una advertencia que nos indica que será necesario borrar la tabla, borrar las referencias que existan a ellas y volver a crearlas, durante este proceso se crean tablas temporales con la nueva estructura, se pasan los datos y se crean las tablas nuevas con la nueva estructura. Esta es una operación que requiere muchos recursos del servidor, es por esta razón que no se permite por defecto. Para cambiar este comportamiento tiene que cambiar la opción en Menu >> Tools >> Options >> Designers >> Uncheck “Prevent Saving changes that require table re-creation”.

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

 

MVP Award 2009

Les comparto que me han renovado el MVP para el año 2009, adjunto parte del mensaje recibido

 

Estimado/a Eduardo Castro,

Enhorabuena. Nos complace presentarle el programa de nombramiento MVP de Microsoft® de 2009. Este nombramiento se concede a los líderes excepcionales de la comunidad técnica que comparten de forma activa su experiencia de alta calidad y de la vida real con otras personas. Le agradecemos especialmente la contribución que ha realizado en las comunidades técnicas en el área de SQL Server a lo largo del pasado año.

 

Saludos,

Eduardo Castro – Microsoft SQL Server

Costa Rica

http://comunidadwindows.org

 

Cómo agregar a un usuario como sysadmin en SQL Server de forma forzada

Si por algún motivo no puedes tener acceso a una instancia de SQL Server 2005 o 2008 y tienes una cuenta que es administrador local del equipo puedes seguir los siguientes pasos para agregarlo al rol de sysadmin

1. Detenga el servicio de SQL Server

2. Habra un command prompt y vaya al directorio

 SQLInstall\Microsoft SQL Server\MSSQL.X\MSSQL\Binn

3. Inicie SQL Server, si es una instancia nombrada ejecute sqlservr.exe -sNombreInstancia -m –c

Si es la instancia por default ejecute

sqlservr.exe -m –c

4. Abra otro command prompt y digite

sqlcmd -SComputerName\NombreInstancia

o lo siguiente es la instancia por default

sqlcmd –SComputerName

5. Ejecute el siguiente comando

sp_addsrvrolemember '<Login>', 'sysadmin'
GO

 

6.Cierre todas las ventanas y reincie SQL Server.

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

 

KPI creados en cubos de SQL Server muestran etiqueta ERROR en Performance Point

Si se crea un KPI con MDX en un cubo de SQL Server, cuando dicha información se despliega en Performance Point Server 2007, en lugar del valor del KPI se muestra una etiqueta que dice ERROR para las columnas de value y goal tal y como se muestra en la siguiente figura:

PAra solucionarlo primero es recomendable instalar el SP2 de Performance Point, más detalles en http://office.microsoft.com/download/afile.aspx?AssetID=AM103381121033, además se debe verificar que el Application Pool del SharePoint y el application pool del Monitoring Server están configurados adecuadamente. Para más detalles consultar http://technet.microsoft.com/en-us/library/bb905547.aspx

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

 

SQL Server en Windows Server 2003 Enterprise 32bits con 32GB de RAM

Si desea configurar un servidor de SQL Server en 32 bits y desea que el sistema operativo reconozca 32GB de RAM, puede tomar en cuenta las siguientes consideraciones.

Si usted desea mantener el sistema operativo en 32 bits, entonces su opción es tener Windows 2003 Enterprise configurado con PAE. Consulte lo siguiente:

PAE Mode http://www.microsoft.com/whdc/system/platform/server/PAE/pae_os.mspx
PAE is the second method supported to access memory above 4 GB; this method has been widely implemented. PAE maps up to 64 GB of physical memory into a 32-bit (4 GB) virtual address space using either 4-KB or 2-MB pages. The Page directories and the page tables are extended to 8 byte formats, allowing the extension of the base addresses of page tables and page frames to 24 bits (from 20 bits). This is where the extra four bits are introduced to complete the 36-bit physical address.

Windows supports PAE with 4-KB pages. PAE also supports a mode where 2-MB pages are supported. Many of the UNIX operating systems rely on the 2 MB-page mode. The address translation is done without the use of page tables (the PDE supplies the page frame address directly).

Para configurar PAE en Windows 2003 puede consultar este artículo http://msdn.microsoft.com/en-us/library/ms791485.aspx

Este es un ejemplo de cómo configurar PAE en Windows 2003

Primer Boot.ini:

[boot loader]

timeout=0

default=multi(0)disk(0)rdisk(0)partition(1)\WINNT

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINNT=” Windows Server 2003, Enterprise” /fastdetect

Cambie el Boot.ini de la siguiente forma:

[boot loader]

timeout=0

default=multi(0)disk(0)rdisk(0)partition(1)\WINNT

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINNT=” Windows Server 2003, Enterprise” /fastdetect /PAE

Si lo desea realizar por medio del commando Bootcfg utilice lo siguiente:

bootcfg /raw "/pae" /A /ID 1

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

 

Microsoft pasa las pruebas de antivirus

La herramienta ForeFront Client Security y Windows Live One Care, pasaron las pruebas de antivirus, pueden ver todo el reporte en http://www.icsalabs.com/icsa/topic.php?tid=d3a8$95695e0b-40700fe6$8dd1-8fc093ea

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

 

 

May 2009 Testing Report Desktop/Server Monthly Detection (4.0) Vendor Product OS Criteria Pass/Fail +/- ALWIL Software Avast 4 Win XP Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 4.8.1335 5/15/2009 5/15/2009 Passed On-Demand Scan of Wild List 4.8.1335 5/15/2009 5/15/2009 Passed +/- ALWIL Software Avast 4 Server Edition Win 2003 Server Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 4.8 5/13/2009 5/14/2009 Passed On-Demand Scan of Wild List 4.8 5/13/2009 5/14/2009 Passed +/- Authentium Command Antivirus for Windows Win XP Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 4.95.2 5/13/2009 5/14/2009 Passed On-Demand Scan of Wild List 4.95.2 5/13/2009 5/14/2009 Passed +/- AVG Technologies AVG Antivirus Professional Edition Win XP Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.5.336 5/14/2009 5/14/2009 Passed On-Access Detection of Wild List 8.1.660 5/14/2009 5/14/2009 Failed On-Demand Scan of Wild List 8.5.336 5/14/2009 5/14/2009 Passed On-Demand Scan of Wild List 8.1.660 5/14/2009 5/14/2009 Failed +/- AVG Technologies AVG File Server Edition Win 2000 Server Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.5.339 5/20/2009 5/20/2009 Passed On-Demand Scan of Wild List 8.5.339 5/20/2009 5/20/2009 Passed +/- AVG Technologies AVG File Server Edition Win 2003 Server Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.5.336 5/14/2009 5/14/2009 Passed On-Demand Scan of Wild List 8.5.336 5/14/2009 5/14/2009 Passed +/- AVG Technologies AVG Professional Vista 32-bit Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.5.339 5/18/2009 5/18/2009 Passed On-Demand Scan of Wild List 8.5.339 5/18/2009 5/18/2009 Passed +/- AVG Technologies AVG Professional Vista 64-bit Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.5.339 5/18/2009 5/18/2009 Passed On-Demand Scan of Wild List 8.5.339 5/18/2009 5/18/2009 Passed +/- Avira GmbH AntiVir Windows Workstation Linux Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 2.1.12-161 5/14/2009 5/18/2009 Passed On-Demand Scan of Wild List 2.1.12-161 5/14/209 5/18/2009 Passed +/- BitDefender SRL BitDefender Antivirus Vista 32-bit Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 12.0.12 5/11/2009 5/11/2009 Passed On-Demand Scan of Wild List 12.0.12 5/11/2009 5/11/2009 Passed +/- BullGuard Ltd. BullGuard Win 2000 Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 7.25481 5/18/2009 5/20/2009 Passed On-Demand Scan of Wild List 7.25481 5/18/2009 5/20/2009 Passed +/- BullGuard Ltd. Bullguard Internet Security Vista 32-bit Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.1.637.0 5/12/2009 5/12/2009 Passed On-Access Detection of Wild List 8.1.637.0 5/12/2009 5/12/2009 Failed On-Demand Scan of Wild List 8.1.637.0 5/12/2009 5/12/2009 Passed On-Demand Scan of Wild List 8.1.637.0 5/12/2009 5/12/2009 Failed +/- BullGuard Ltd. Bullguard Internet Security Vista 64-bit Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.1.637.0 5/12/2009 5/12/2009 Passed On-Demand Scan of Wild List 8.1.637.0 5/12/2009 5/12/2009 Passed +/- CA, Inc. CA Anti-Virus Vista 32-bit Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 9.0.0.17 5/26/2009 5/11/2009 Passed On-Access Detection of Wild List 9.0.0.174 5/8/2009 5/11/2009 Failed On-Demand Scan of Wild List 9.0.0.174 5/26/2009 5/11/2009 Passed On-Demand Scan of Wild List 9.0.0.174 5/8/2009 5/11/2009 Failed +/- CA, Inc. CA Anti-Virus Win XP Home Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 9.0.0.175 5/26/2009 5/15/2009 Passed On-Access Detection of Wild List 9.0.0.174 5/15/2009 5/15/2009 Failed On-Demand Scan of Wild List 9.0.0.174 5/15/2009 5/15/2009 Passed +/- CA, Inc. CA Anti-Virus for the Enterprise Linux Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 7.1.2885 5/27/2009 5/27/2009 Passed On-Access Detection of Wild List 7.1.2885 5/16/2009 5/18/2009 Failed On-Demand Scan of Wild List 7.1.2885 5/27/2009 5/27/2009 Passed On-Demand Scan of Wild List 7.1.2885 5/16/2009 5/18/2009 Failed +/- CA, Inc. CA Anti-Virus for the Enterprise Win 2000 Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.1.660.0 5/26/2009 5/26/2009 Passed On-Demand Scan of Wild List 8.1.660.0 5/26/2009 5/26/2009 Passed +/- CA, Inc. CA Anti-Virus for the Enterprise Win 2000 Server Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.1.660.0 5/26/2009 5/15/2009 Passed On-Access Detection of Wild List 8.1.660.0 5/15/2009 5/15/2009 Failed On-Demand Scan of Wild List 8.1.660.0 5/26/2009 5/15/2009 Passed On-Demand Scan of Wild List 8.1.660.0 5/15/2009 5/15/2009 Failed +/- CA, Inc. CA Anti-Virus for the Enterprise Win 2003 Server Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.1.660.0 5/26/2009 5/26/2009 Passed On-Demand Scan of Wild List 8.1.660.0 5/26/2009 5/26/2009 Passed +/- CA, Inc. CA Anti-Virus for the Enterprise Win XP Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.1.660 5/22/2009 5/15/2009 Passed On-Access Detection of Wild List 8.1.660 5/14/2009 5/15/2009 Failed On-Demand Scan of Wild List 8.1.660 5/22/2009 5/15/2009 Passed On-Demand Scan of Wild List 8.1.660 5/14/2009 5/15/2009 Failed +/- ESET, LLC ESET NOD32 Antivirus Vista 64-bit Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 3.0.672.0 5/18/2009 5/18/2009 Passed On-Demand Scan of Wild List 3.0.672.0 5/18/2009 5/18/2009 Passed +/- ESET, LLC ESET NOD32 Antivirus Win XP Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 3.0.667.0 5/15/2009 5/15/2009 Passed On-Demand Scan of Wild List 3.0.667.0 5/15/2009 5/15/2009 Passed +/- F-Secure Corporation F-Secure AntiVirus Internet Security Vista 32-bit Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.0 build 101 5/11/2009 5/11/2009 Passed On-Demand Scan of Wild List 8.0 build 101 5/11/2009 5/11/2009 Passed +/- F-Secure Corporation F-Secure AntiVirus Internet Security Win XP Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.10 build 14240 5/15/2009 5/15/2009 Passed On-Demand Scan of Wild List 8.10 build 14240 5/15/2009 5/15/2009 Passed +/- IBM Internet Security Systems Proventia Desktop Endpoint Security Win XP Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 9.0.226.2270 5/14/2009 5/14/2009 Passed On-Demand Scan of Wild List 9.0.226.2270 5/14/2009 5/14/2009 Passed +/- Kaspersky Lab ZAO Kaspersky Internet Security Vista 32-bit Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.0.0.357 5/12/2009 5/13/2009 Passed On-Demand Scan of Wild List 8.0.0.357 5/12/2009 5/13/2009 Passed +/- Kaspersky Lab ZAO Kaspersky Internet Security Win XP Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.0.0.506 5/18/2009 5/18/2009 Passed On-Demand Scan of Wild List 8.0.0.506 5/18/2009 5/18/2009 Passed +/- McAfee, Inc. VirusScan Win XP Home Desktop/Server Monthly Detection Fail Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 13.3.127 5/20/2009 5/20/2009 Failed On-Demand Scan of Wild List 13.3.127 5/20/2009 5/20/2009 Failed +/- McAfee, Inc. VirusScan Enterprise Vista 32-bit Desktop/Server Monthly Detection Fail Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.7.0i 5/11/2009 5/12/2009 Failed On-Access Detection of Wild List 8.5.0i 5/11/2009 5/12/2009 Failed On-Demand Scan of Wild List 8.7.0i 5/18/2009 5/18/2009 Failed +/- McAfee, Inc. VirusScan Enterprise Vista 64-bit Desktop/Server Monthly Detection Fail Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.7.0i 5/18/2009 5/18/2009 Failed On-Demand Scan of Wild List 8.7.0i 5/18/2009 5/18/2009 Failed +/- McAfee, Inc. VirusScan Enterprise Win 2003 Server Desktop/Server Monthly Detection Fail Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.7.0 5/13/2009 5/14/2009 Failed On-Demand Scan of Wild List 8.7.0 5/13/2009 5/14/2009 Failed +/- McAfee, Inc. VirusScan Enterprise Win XP Pro Desktop/Server Monthly Detection Fail Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.7.0i 5/26/2009 5/27/2009 Failed On-Demand Scan of Wild List 8.7.0i 5/26/2009 5/27/2009 Failed +/- Microsoft Corporation Microsoft ForeFront Client Security Vista 32-bit Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 1.5.1958.0 5/10/2009 5/11/2009 Passed On-Access Detection of Wild List 1.5.1958.0 5/10/2009 5/11/2009 Failed On-Demand Scan of Wild List 1.5.1958.0 5/10/2009 5/11/2009 Passed On-Demand Scan of Wild List 1.5.1958.0 5/10/2009 5/11/2009 Failed +/- Microsoft Corporation Microsoft ForeFront Client Security Win 2000 Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 1.5.1958.0 1.57.1651.0 5/20/2009 Passed On-Demand Scan of Wild List 1.5.1958.0 1.57.1651.0 5/20/2009 Passed +/- Microsoft Corporation Microsoft ForeFront Client Security Win 2003 Server Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 1.5.1958.0 1.57.1329.0 5/14/2009 Passed On-Demand Scan of Wild List 1.5.1958.0 1.57.1329.0 5/14/2009 Passed +/- Microsoft Corporation Microsoft ForeFront Client Security Win XP Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 1.5.1955.0 5/19/2009 5/19/2009 Passed On-Demand Scan of Wild List 1.5.1955.0 5/19/2009 5/19/2009 Passed +/- Microsoft Corporation Windows Live OneCare Vista 64-bit Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 2.5.2900.24 5/12/2009 5/13/2009 Passed On-Demand Scan of Wild List 2.5.2900.20 5/18/2009 5/19/2009 Passed +/- Norman Norman Virus Control Win 2003 Server Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 5.99 6/3/2009 6/8/2009 Passed On-Access Detection of Wild List 5.99 6/1/2009 6/1/2009 Failed On-Access Detection of Wild List 5.99 6/1/2009 5/26/2009 Failed On-Access Detection of Wild List 5.99 5/26/2009 5/26/2009 Failed On-Demand Scan of Wild List 5.99 6/3/2009 6/8/2009 Passed On-Demand Scan of Wild List 5.99 6/1/2009 6/1/2009 Failed On-Demand Scan of Wild List 5.99 5/26/2009 5/26/2009 Failed +/- Panda Security Panda AntiVirus Pro 2009 Win XP Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.00.00 5/19/2009 5/20/2009 Passed On-Access Detection of Wild List 8.00.00 5/19/2009 5/20/2009 Failed On-Demand Scan of Wild List 8.00.00 5/19/2009 5/20/2009 Passed On-Demand Scan of Wild List 8.00.00 5/19/2009 5/20/2009 Failed +/- Panda Security Panda for Desktops Win XP Pro Desktop/Server Monthly Detection Fail Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 4.02.32 5/14/2009 5/15/2009 Failed On-Demand Scan of Wild List 4.02.32 5/14/2009 5/15/2009 Failed +/- Panda Security Panda for FileServers Win 2003 Server Desktop/Server Monthly Detection Fail Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 8.02.32 5/14/2009 5/14/2009 Failed On-Demand Scan of Wild List 8.02.32 5/14/2009 5/14/2009 Failed +/- Panda Security Panda Internet Security 2009 Win XP Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 14.00.00 5/13/2009 5/13/2009 Passed On-Demand Scan of Wild List 14.00.00 5/13/2009 5/13/2009 Passed +/- PC TOOLS PC Tools Antivirus Win XP Pro Desktop/Server Monthly Detection Fail Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 6.0.0.19 6/2/2009 6/2/2009 Failed On-Access Detection of Wild List 6.0.0.19 5/15/2009 5/15/2009 Failed On-Access Detection of Wild List 6.0.0.19 5/15/2009 5/15/2009 Failed On-Demand Scan of Wild List 6.0.0.19 6/2/2009 6/2/2009 Failed On-Demand Scan of Wild List 6.0.0.19 5/15/2009 5/15/2009 Failed On-Demand Scan of Wild List 6.0.0.19 5/15/2009 5/15/2009 Failed +/- Radialpoint Radialpoint Internet Security Suite v.6.0 Win XP Home Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 6.0.4.27425 5/19/2009 5/20/2009 Passed On-Demand Scan of Wild List 6.0.4.27425 5/19/2009 5/20/2009 Passed +/- Radialpoint RadialPoint Internet Security Suite v.7.0 Vista 32-bit Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 7.0.22.31377 5/12/2009 5/13/2009 Passed On-Demand Scan of Wild List 7.0.22.31377 5/12/2009 5/13/2009 Passed +/- Symantec Corporation Norton Antivirus Win XP Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 16.5.0.134 5/14/2009 5/14/2009 Passed On-Demand Scan of Wild List 16.5.0.134 5/14/2009 5/14/2009 Passed +/- Symantec Corporation Norton Antivirus 2009 Vista 64-bit Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 16.5.0.134 5/12/2009 5/13/2009 Passed On-Demand Scan of Wild List 16.5.0.134 5/12/2009 5/13/2009 Passed +/- Symantec Corporation Symantec Endpoint Protection Vista 32-bit Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 11.0.780.1109 5/19/2009 6/12/2009 Passed On-Demand Scan of Wild List 11.0.780.1109 5/19/2009 6/12/2009 Passed +/- Symantec Corporation Symantec Endpoint Protection Win 2003 Server Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 11.0.780.1109 5/14/2009 5/15/2009 Passed On-Demand Scan of Wild List 11.0.780.1109 5/14/2009 5/15/2009 Passed +/- Symantec Corporation Symantec Endpoint Protection Win XP Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 11.0.780.1109 5/19/2009 5/21/2009 Passed On-Demand Scan of Wild List 11.0.780.1109 5/19/2009 5/21/2009 Passed +/- VirusBuster VirusBuster Win XP Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 5.3.157 6/10/2009 6/11/2009 Passed On-Access Detection of Wild List 5.3.157 6/4/2009 6/4/2009 Failed On-Access Detection of Wild List 5.3.157 5/19/2009 5/20/2009 Failed On-Demand Scan of Wild List 5.3.157 6/10/2009 6/11/2009 Passed On-Demand Scan of Wild List 5.3.157 6/4/2009 6/4/2009 Failed On-Demand Scan of Wild List 5.3.157 5/19/2009 5/20/2009 Failed +/- Webroot Software, Inc. Webroot AntiVirus (WAV) Win XP Home Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 6.1.0 Build 128 6/8/2009 6/8/2009 Passed On-Access Detection of Wild List 6.0.2.39 6/2/2009 6/3/2009 Failed On-Access Detection of Wild List 6.0.2.39 5/19/2009 5/20/2009 Failed On-Demand Scan of Wild List 6.1.0 Build 128 6/8/2009 6/8/2009 Passed On-Demand Scan of Wild List 6.0.2.39 6/2/2009 6/3/2009 Failed On-Demand Scan of Wild List 6.0.2.39 5/19/2009 5/20/2009 Failed +/- Webroot Software, Inc. Webroot Internet Security Essentials (WISE) Win XP Pro Desktop/Server Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of Wild List 6.1.0 Build 128 6/8/2009 6/8/2009 Passed On-Access Detection of Wild List 6.1.0 Build 128 6/3/2009 6/3/2009 Failed On-Access Detection of Wild List 6.1.0 Build 128 5/26/2009 5/26/2009 Failed On-Access Detection of Wild List 6.1.0 Build 128 5/26/2009 5/26/2009 Failed On-Demand Scan of Wild List 6.1.0 Build 128 6/8/2009 6/8/2009 Passed On-Demand Scan of Wild List 6.1.0 Build 128 6/3/2009 6/3/2009 Failed On-Demand Scan of Wild List 6.1.0 Build 128 5/26/2009 5/27/2009 Failed ECM (4.0) Vendor Product OS Criteria Pass/Fail +/- Microsoft Corporation Microsoft ForeFront Security for SharePoint Windows Server 2003 ECM Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of the ECM Test Set 10.1.0802.0 05/21/2009 5/21/2009 Passed On-Demand Detection of the ECM Test Set 10.1.0802.0 05/21/2009 5/21/2009 Passed On-Demand Detection of the ECM Test Set 10.1.0802.0 05/21/2009 5/21/2009 Passed +/- Microsoft Corporation Microsoft ForeFront Security for SharePoint Windows Server 2008 ECM Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of the ECM Test Set 10.1.0802.0 05/20/2009 5/20/2009 Passed On-Demand Detection of the ECM Test Set 10.1.0802.0 05/20/2009 5/20/2009 Passed Gateway Monthly Detection (4.0) Vendor Product OS Criteria Pass/Fail +/- Anchiva Systems, Inc. Anchiva 206 Appliance Gateway Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail Mail On-Access 206 5/13/2009 5/13/2009 Passed Mail On-Access 206 5/13/2009 5/13/2009 Failed +/- Fortinet, Inc. Fortigate Appliance Gateway Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail Mail On-Access 3600 05/26/2009 5/12/2009 Passed Mail On-Access 3600 05/12/2009 5/12/2009 Failed +/- Secure Computing Corporation Webwasher Linux Gateway Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail Mail On-Access 6.7.1 build 3376 06/02/2009 5/14/2009 Passed Mail On-Access 6.7.1 build 3376 05/14/2009 5/14/2009 Failed Groupware Monthly Detection (4.0) Vendor Product OS Criteria Pass/Fail +/- GFI Software LTD MailSecurity Microsoft Exchange 2000 Groupware Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of the Mail Test Set 10.0 Build 20060721 05/14/2009 5/14/2009 Passed +/- McAfee, Inc. Groupshield Lotus Domino Groupware Monthly Detection Fail Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of the Mail Test Set 5.3 05/14/2009 5/14/2009 Failed +/- McAfee, Inc. Groupshield Microsoft Exchange 2000 Groupware Monthly Detection Fail Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of the Mail Test Set 6.0.616.102 05/13/2009 5/14/2009 Failed +/- Microsoft Corporation Microsoft ForeFront Security for Exchange Server Exchange 2007 on Windows Server 2003 Groupware Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of the Mail Test Set 10.0.0566.0 05/18/2009 5/18/2009 Passed +/- Microsoft Corporation Microsoft ForeFront Security for Exchange Server Exchange 2007 on Windows Server 2008 Groupware Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of the Mail Test Set 10.1.0746.0 05/21/2009 5/21/2009 Passed +/- Symantec Corporation Mail Security Lotus Domino Groupware Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of the Mail Test Set 7.5.0.19 05/13/2009 5/14/2009 Passed +/- Symantec Corporation Mail Security Microsoft Exchange Groupware Monthly Detection Pass Test Details: Test Version Signature Test Date Pass/Fail On-Access Detection of the Mail Test Set 5.0.3.360 05/14/2009 5/14/2009 Passed

 

Guía de consolidación para SQL Server

HP ha publicado una guía sobre recomendaciones para realizar consolidación de servidores SQL Server, los escenarios cubiertos en esa guía son los siguientes:

• Consolidar múltiples bases de datos dentro un único servidor
• Consolidar varias instancias de SQL Server en menos servidores físicos
• Consolidar SQL Server por medio de la virtualización

La guía la pueden bajar de la siguiente dirección

http://windowsitpro.com/essential/index.cfm?fuseaction=show&guid=4a8c98eb-a186-49b1-ab69-cf52f0307c2b&code=EPDedHPBladesEG01_062209

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server