declare @fileName varchar(200);
declare @timstamp varchar(100);
?
set @timstamp = REPLACE(REPLACE(CURRENT_TIMESTAMP,' ','_'),':','_');
?
set @fileName = CONCAT(N'J:\MSSQL_BACKUP\AxDB_backup_',@timstamp, '.bak');
?
BACKUP DATABASE [AxDB] TO? DISK = @filename WITH NOFORMAT, NOINIT,?
NAME = N'AxDB_backup', SKIP, REWIND, NOUNLOAD, COMPRESSION,?CHECKSUM
?
GO
H@ppy D@xing...!
No comments:
Post a Comment