Automated Sql server Backup

Sql Server administrators often need to backup databases and preferably automated. following script will create backups of all databases other than specified, Script will create separate directory of backups, currently this script runs daily and creates daily directory. to create physical directory using Sql we need to enable a stored procedure “xp_cmdshell” and that can only be enabled when […]