SQL express backup
Posted on 2013-11-13
I want to backup SQL express. I have management studio 2008 installed and although there is an option to backup the DB I cannot find any where to run this on schedule.
While running a manual backup I select script and it outputted the script it was running which reads
BACKUP DATABASE [stock] TO DISK = N'D:\Stock_DB_Backup\Stock_Nov_11_2013' WITH NOFORMAT, NOINIT, NAME = N'Stock-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
I want to automate this process to have a full backup. I want each backup to have a filename that increments 01-02-03 as oppose to overwriting the previous days backup.
If someone can tell me specifically what I need to do without sending me to a technet link : )