How to reset Windows 2003/2008 Service SDDL ACL


What is SDDL? SDDL stands for “Security Descriptor Definition Language”, the definition from Microsoft “The security descriptor definition language (SDDL) defines the string format that the ConvertSecurityDescriptorToStringSecurityDescriptor and ConvertStringSecurityDescriptorToSecurityDescriptor functions use to describe a security descriptor as a text string. The language also defines string elements for describing information in the components of a security […]

Check which databases have been restored recently


A simple script I found to help see which databases have been restored recently, good thing to check if you are troubleshooting SQL 2005/2008 backup issues. SELECT [rs].[destination_database_name], [rs].[restore_date], [bs].[backup_start_date], [bs].[backup_finish_date], [bs].[database_name] as [source_database_name], [bmf].[physical_device_name] as [backup_file_used_for_restore] FROM msdb..restorehistory rs INNER JOIN msdb..backupset bs ON [rs].[backup_set_id] = [bs].[backup_set_id] INNER JOIN msdb..backupmediafamily bmf ON [bs].[media_set_id] = […]