SYSTEM_USER - returns the current login name. If the current user is logged in to SQL Server by using Windows Authentication, SYSTEM_USER returns the Windows login identification name in the form: DOMAIN\user_login_name. However, if the current user is logged in to SQL Server by using SQL Server Authentication, SYSTEM_USER returns the SQL Server login identification name, such as developer for a user logged in as developer
BackUp infromation- use the msdb DB to get information about DBs BackUps that have done.
SELECT database_name, user_name as ExecutedBy, bckset.[type],bckset.[compatibility_level], physical_device_name,backup_finish_date, backup_finish_date
FROM msdb..backupset bckset INNER JOIN msdb..backupmediafamily bckfmly ON bckset.media_set_id = bckfmly.media_set_id
order by bckset.backup_finish_date desc
Getting the current versions of the server - run this command
select @@version
Get the Compatibility of the DB's in the instance
USE master
GO
SELECT name DbName, compatibility_level FROM sys.databases
Get the Files Size of all databases include Data Files & Log Files
Select db.[dbid] as 'DB ID',
db.[name] as 'Database Name',
af.[name] as 'Logical Name',
af.[size] as 'File Size (in 8-kilobyte (KB) pages)',
(((CAST(af.[size] as DECIMAL(18,4)) * 8192) /1024) /1024) as 'File Size (MB)',
((((CAST(af.[size] as DECIMAL(18,4)) * 8192) /1024) /1024) /1024) as 'File Size (GB)',
af.[filename] as 'Physical Name'
from sys.sysdatabases db inner join sys.sysaltfiles af
on db.dbid = af.dbid
where (Af.status & 0x40)=0 --without this condition the log files
--will be return too
--db.[name]=<DB Name>--To check for spcific DB
order by 'File Size (MB)' desc