using System;
public class Program
{
public static void Main()
Console.WriteLine("Hello World");
/*
USE master
go
DECLARE @dir VARCHAR(100)
IF (DATEPART(HOUR,GETDATE()) = 0)
BEGIN
SET @dir = 'Daily'
END
ELSE
SET @dir = 'Current'
DECLARE @fileName VARCHAR(200)
SET @fileName = 'd:\!Backup\CurrentBackup\' + @dir + '\mtrace-'+CAST(DATEPART(YEAR,GETDATE()) AS VARCHAR(100))+ '-'+CAST(DATEPART(MONTH,GETDATE()) AS VARCHAR(100))+ '-'+ CAST(DATEPART(DAY,GETDATE()) AS VARCHAR(100))+ '-'+CAST(DATEPART(HOUR,GETDATE()) AS VARCHAR(100)) +'.bak'
BACKUP DATABASE [mtrace] TO DISK = @fileName
WITH NOFORMAT, INIT, NAME = N'MyDataBase1 Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
DECLARE @fileNameLog VARCHAR(200)
SET @fileNameLog = 'd:\!Backup\CurrentBackup\' + @dir + '\mtrace-log-'+CAST(DATEPART(YEAR,GETDATE()) AS VARCHAR(100))+ '-'+CAST(DATEPART(MONTH,GETDATE()) AS VARCHAR(100))+ '-'+ CAST(DATEPART(DAY,GETDATE()) AS VARCHAR(100))+ '-'+CAST(DATEPART(HOUR,GETDATE()) AS VARCHAR(100)) +'.bak'
BACKUP LOG [mtrace] TO DISK = @fileNameLog
WITH NOFORMAT, NOINIT, NAME = N'TSQL-TRN Database Backup', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10
GO
USE mtrace
dbcc shrinkfile(2, emptyfile)
dbcc shrinkfile(4, emptyfile)
DECLARE
@dbbackupfile VARCHAR(1000),
@logbackupfile VARCHAR(1000),
@dbname VARCHAR(200)
SET @dbbackupfile = '{dbBackupFile}'
SET @logbackupfile = '{logBackupFile}'
SET @dbname = '{dbName}'
BACKUP DATABASE {cmdDbName} TO DISK = @dbbackupfile
WITH NOFORMAT, INIT, NAME = N'db', SKIP, NOREWIND, NOUNLOAD, STATS = 10
BACKUP LOG {cmdDbName} TO DISK = @logbackupfile
WITH NOFORMAT, NOINIT, NAME = N'log', SKIP, NOREWIND, NOUNLOAD, STATS = 10
*/
}