How to reset Windows 2003/2008 Service SDDL ACL

2012-11-23

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

2010-12-25

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] = […]