Business Central SaaS Exporting Database Backup and Restore it on your Sql Server

Business Central SaaS Exporting Database Backup and Restore it on your Sql Server Since some days, Microsoft has activated the feature for downloading a backup of a Business Central SaaS Azure SQL Database directly from Admin Center. A selected database (in this case a BC v15 Wave 2 production database) can be backuped and exported … Read more

Microsoft solution to automate backup on SQL Express

Microsoft solution to automate backup on SQL Express NB: SQL Server Agent is not available  on this SQL release Microsoft Solution  https://support.microsoft.com/en-us/kb/2019698 Sample Backup.cmd file sqlcmd -U sa -P xxxx -S .\SQL2012EXPRESS -Q “EXEC sp_BackupDatabases @backupLocation = ‘C:\SQLBackups\’, @backupType = ‘F’” You can schedule jobs with standard “Windows Jobs“ Post Views: 791

%d bloggers like this: