What do you get if you run this?

SELECT MAX(backup_size)
FROM msdb..backupset
WHERE database_name = 'toto'
AND backup_finish_date > CURRENT_TIMESTAMP - 14
AND type = 'L'

Please read about crosstabs and pivots - that will help you to get the results you're looking for from your sample data.  If you have an unspecified number of items,...

Well, you can't make any log backups until you've made a full backup.  Therefore if you want point-in-time recovery capability in test/dev right from the start then yes, you need...

Where are you restoring the database?  I can't think of any reason to do another backup just because you've restored from a backup of the same database.  The only thing...

I think it depends on the default language for the server, which you can find in sys.configurations.
SELECT l.name, l.alias
FROM sys.configurations c
JOIN sys.syslanguages l ON c.value_in_use...

You could set up a daily job (or whatever frequency is appropriate) to look for jobs that aren't owned by the SQL Server Agent service account, and change them so...

Anthony

Don't do either.  Not yet, at least.  If you're worried about the growth of your log file, make sure you are making frequent log backups (unless you're in...

SELECT
     id
,    Name
,    'temp1' AS SourceTable
FROM #temp1
UNION ALL
SELECT
     id
,    Name
,    'temp2'
FROM #temp2

John

This almost works, but please will you check your logic for Company 2, Item 1 - it should be 55 + 23 = 78, shouldn't it?

SELECT

Yes please - and preferably also without one of Companyname and Dataname_key.

John