Scheduled Tasks:
Execute .bat file, from the folder, choose une day
.bat File:
sqlcmd -S .\SQLEXPRESS -E -Q “EXEC sp_BackupDatabases @backupLocation=’C:\where_to_put_bak_file\’, @databaseName=’db_name’, @backupType=’F'”
Scheduled Tasks:
Execute .bat file, from the folder, choose une day
.bat File:
sqlcmd -S .\SQLEXPRESS -E -Q “EXEC sp_BackupDatabases @backupLocation=’C:\where_to_put_bak_file\’, @databaseName=’db_name’, @backupType=’F'”