About Will

Background on Microsoft Access

Microsoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a GUI and software development tools. It is a member of the Microsoft Office suite of applications and is included in the Professional and higher versions for Office and also sold separately.

Origins of PHP

Hypertext Preprocessor (PHP) is a widely used, general-purpose scripting language that was originally designed for Web Development to produce dynamic web pages.

If your firm is in Gaithersburg, Germantown, Rockville, or anywhere in the Maryland area, and you need some help with computer programming, please contact us!

Corbin Creative Databases, LLC

SQL Server missing transaction logs

Is there there an easy way to determine if you are missing transaction logs for a SQL Server database?

Yes!

Try the following code:

SELECT D.[name] AS [db_name], D.[rec_model_desc]
FROM sys.databases D LEFT JOIN
(
SELECT BS.[db_name],
MAX(BS.[backup_finish_date]) AS [last_log_backup_date]
FROM msdb.dbo.backupset BS
WHERE BS.type = ‘L’
GROUP BY BS.[db_name]
) BS1 ON D.[name] = BS1.[db_name]
WHERE D.[rec_model_desc] <> ‘SIMPLE’
AND BS1.[last_log_backup_date] IS NULL
ORDER BY D.[name];