SQL Db backup script in AX 7/D365

Hi All, Please find the below script which could be used to backup and DB from SQL to local file location.


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