declare @filename nvarchar(100) = '';
set @filename=N'C:\backup_' + CONVERT(nvarchar(20), getdate(), 120) + '.bak';
print @filename;

set @filename=N'C:\backup_*.bak' 

set @filename=N'C:\backup_' + REPLACE(convert(nvarchar(20),GetDate(),120),':','-') + '.bak';
BACKUP DATABASE [db] TO  DISK = @filename

RESTORE VERIFYONLY FROM  DISK = @filename 

set @filename=N'C:\backup_' + REPLACE(convert(nvarchar(20),GetDate(),120),':','-') + '.bak';

set @filename=N'C:\backup_' + REPLACE(convert(nvarchar(20),GetDate(),120),':','-') + '.bak';
RESTORE VERIFYONLY FROM  DISK = @filename 

use master
declare @db_name varchar(100)
set @db_name='dbnane'--заменить на имя вашей базы.
SELECT 
CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server, 
msdb.dbo.backupset.database_name, 
msdb.dbo.backupset.backup_start_date, 
msdb.dbo.backupset.backup_finish_date, 
msdb.dbo.backupset.expiration_date, 
CASE msdb..backupset.type 
WHEN 'D' THEN 'Database' 
WHEN 'L' THEN 'Log' 
END AS backup_type, 
msdb.dbo.backupset.backup_size, 
msdb.dbo.backupmediafamily.logical_device_name, 
msdb.dbo.backupmediafamily.physical_device_name, 
msdb.dbo.backupset.name AS backupset_name, 
msdb.dbo.backupset.description 
FROM msdb.dbo.backupmediafamily 
INNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id 
WHERE (CONVERT(datetime, msdb.dbo.backupset.backup_start_date, 102) >= GETDATE() - 7) 
and database_name=@db_name
and charindex('\',physical_device_name) >0
ORDER BY 
msdb.dbo.backupset.database_name, 
msdb.dbo.backupset.backup_finish_date DESC

convert(varchar(500),GetDate(),112)

SELECT FORMAT(getdate(),'yyyy-MM-dd hh-mm-ss')