Backup with Trigger
how do one backup/day trigger in sql server 2008,
for example: want make trigger make backup every day @ 01:00 am.
thx
for example: want make trigger make backup every day @ 01:00 am.
thx
hi
i solved whit task in windows. running line:
sqlcmd.exe -q "
declare @nome varchar(255);
set @nome = 'd:\backup\banco de dados\bancodadosdptotal ' + replace(getdate(), ':', '-') + '.bak';
backup database [avaliacao] to disk = @nome noformat, noinit, name = n'avaliacao-full database backup', skip, norewind, nounload, stats = 10;"
thx
i solved whit task in windows. running line:
sqlcmd.exe -q "
declare @nome varchar(255);
set @nome = 'd:\backup\banco de dados\bancodadosdptotal ' + replace(getdate(), ':', '-') + '.bak';
backup database [avaliacao] to disk = @nome noformat, noinit, name = n'avaliacao-full database backup', skip, norewind, nounload, stats = 10;"
thx
SQL Server > SQL Server Security
Comments
Post a Comment