• Hi Guys,

    thank you!
    I do not have SQL server Agent and standard SQL edition.

    This code:
    declare @cmd varchar(5000)
    select @cmd ='if ''tempdb'' <> cast(''?'' as nvarchar) backup database [?] to disk =''x:\sql_backup\?\?_2017_06_15.bak'''
    PRINT @cmd
    exec sp_msforeachdb @cmd 

    is for SQL Server Agent or cmd task ? 

    Best Wishes,
    Jacek