Somente executar a query abaixo para averiguar o tamanho dos discos utilizados pela instancia.SELECT DISTINCT VS.volume_mount_point [Montagem],VS.logical_volume_name AS [Volume],CAST(CAST(VS.total_bytes AS DECIMAL(19,2))/1024 /1024 /1024 AS DECIMAL (10,2)) AS [Total (GB)],CAST(CAST(VS.available_bytes AS DECIMAL(19,2))/1024 /1024 /1024 AS DECIMAL (10,2)) AS [Espaco Disponivel (GB)],CAST((CAST(VS.available_bytes AS DECIMAL(19,2)) / CAST(VS.total_bytes AS DECIMAL(19,2)) * 100 ) AS DECIMAL(10,2)) AS [Espaco Disponivel ( % )],CAST((100 - CAST(VS.available_bytes AS DECIMAL(19,2)) / CAST(VS.total_bytes AS DECIMAL(19,2)) * 100) AS DECIMAL (10,2)) AS [Espaco em uso ( % )]FROM sys.master_files AS MFCROSS APPLY [sys].[dm_os_volume_stats](MF.database_id, MF.FILE_ID) AS VSWHERE CAST(VS.available_bytes AS DECIMAL(19,2)) / CAST(VS.total_bytes AS DECIMAL(19,2)) * 100 < 100OBS.: Este comando e somente para Sql Server 2008 Trust assembyO Trust assembly enecessario para assinar executaveis e dlls que serao executadas em locaisdiferentes ao servidor de origem. OBS.: Arquivos .config .xml .txt .log nao e necessariotrustExemplo executavel esta no \\tribanco.com.br\hmldfs\ e seraexecutada na trbsvshml01Framework por versao do visual Studio: Generation Version number Release date Development tool Distributed with 1.0 1.0.3705.0 2002-02-13 Visual Studio .NET N/A 1.1 1.1.4322.573 2003-04-24 Visual Studio .NET 2003 Windows Server 2003 2.0 2.0.50727.42 2005-11-07 Visual Studio 2005 Windows Server 2003 R2 3.0 3.0.4506.30 2006-11-06 Expression Blend Windows Vista, Windows Server 2008 3.5 3.5.21022.8 2007-11-19 Visual Studio 2008 Windows 7, Windows Server 2008 R2 4.0 4.0.30319.1 2010-04-12 Visual Studio 2010 N/A 4.5 4.5.50709.17929 2012-08-15 Visual Studio 2012 Windows 8, Windows Server 2012 Como funcionam as versoes de trust por generation do visualStudio: Versao do trust assembly Generation do viual studio 1.1 1.0 1.1 2.0 2.0 3.0 3.5 Nao e necessario trust 4.0 4.5 Verifica versao do dtsx - 2005SELECT PACK.name AS PackageName ,PACK.isencrypted AS IsEncrypted ,PACK.createdate AS CreateDate ,CONVERT(varchar(10), vermajor) + '.' + CONVERT(varchar(10), verminor) + '.' + CONVERT(varchar(10), verbuild) AS Version ,DATALENGTH(PACK.packagedata) AS PackageSize FROM msdb.dbo.sysdtspackages90 AS PACK where PACK.name in ('PackageName')order by CreateDate descVerifica versao do dtsx - 2008SELECT PACK.name AS PackageName ,PACK.isencrypted AS IsEncrypted ,PACK.createdate AS CreateDate ,CONVERT(varchar(10), vermajor) + '.' + CONVERT(varchar(10), verminor) + '.' + CONVERT(varchar(10), verbuild) AS Version ,DATALENGTH(PACK.packagedata) AS PackageSize FROM msdb.dbo.sysssispackages AS PACK where PACK.name in ('PLDAdviceCargaMovFinanceiro')order by CreateDate desc Apos instalar o windows 8 na minha maquina tive um problema em conectar na vpn que indentifique nos logs:1 12:54:15.440 06/24/12 Sev=Warning/3 CVPND/0xE340000CThe Client was unable to enable the Virtual Adapter because it could not open the device.2 12:54:15.455 06/24/12 Sev=Warning/3 CVPND/0xE340000CThe Client was unable to enable the Virtual Adapter because it could not open the device.3 12:54:15.455 06/24/12 Sev=Warning/2 IKE/0xE300009BFailed to active IPSec SA: Unable to enable Virtual Adapter (NavigatorQM:936)4 12:54:15.455 06/24/12 Sev=Warning/2 IKE/0xE30000A7Unexpected SW error occurred while processing Quick Mode negotiator:(Navigator:2263)Onde a solucao foiAbrir o regedit e va ate : HKLM\SYSTEM\CurrentControlSet\Services\CVirtAFeito isso verifique os casos abaixo:Se x86, altere o valor da seguinte forma "@oem8.inf,%CVirtA_Desc%;Cisco Systems VPN Adapter" para "Cisco Systems VPN Adapter"Se x64, altere o valor da seguinte forma "@oem8.inf,%CVirtA_Desc%;Cisco Systems VPN Adapter for 64-bit Windows" para "Cisco Systems VPN Adapter for 64-bit Windows"Apos isto Funcionou normalmente Este comando verifica a ultima data de cada database da instancia, bem como que foi o executor---------------------------------------------------SELECT T1.Name As ab_taxamedia ,Coalesce(Convert(varchar(12), MAX(T2.Backup_Finish_Date), 101),'Not Yet Taken') As LastBackUpTaken ,Coalesce(Convert(varchar(12), MAX(T2.User_Name), 101), 'NA') As UserNameFROM sys.sysdatabases T1LEFT OUTER