20 lines
No EOL
576 B
Transact-SQL
20 lines
No EOL
576 B
Transact-SQL
CREATE OR ALTER PROCEDURE [dbo].[Adm_T_DatabaseBackupAll]
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
DECLARE @SQL NVARCHAR(MAX) = N'';
|
|
DECLARE @Tarih NVARCHAR(20) = CONVERT(CHAR(8), CAST(SYSUTCDATETIME() AT TIME ZONE 'UTC' AT TIME ZONE 'Turkey Standard Time' AS DATE),112);
|
|
|
|
SELECT @SQL = @SQL + N'
|
|
BACKUP DATABASE ' + QUOTENAME(name) + N'
|
|
TO DISK = N''/var/opt/mssql/backup/'
|
|
+ name + N'_' + @Tarih + N'.bak''
|
|
WITH INIT;'
|
|
FROM sys.databases
|
|
WHERE name NOT IN ('master','model','msdb','tempdb')
|
|
AND state_desc = 'ONLINE';
|
|
|
|
EXEC sp_executesql @SQL;
|
|
END
|
|
GO |