Archives: October 2012
Today, I am going to share few very useful scripts which will report us on Database Backup from different view points.
To get the List/History/Log of all the Successful Backups
b.database_name as DBName,
WHEN b.[type] = 'D' THEN 'Database'
WHEN b.[type] = 'I' THEN
SQL Server has got in-built functions to convert the given string into LOWER() or UPPER() format but it does not provides any direct way to convert it to PROPER format. A string/text is said to be in a PROPER format if all the words in that string/text starts… Read more