troubleshooting Question

SQL express backup

Avatar of Sid_F
Sid_F asked on
Storage SoftwareMicrosoft SQL Server 2008
19 Comments1 Solution812 ViewsLast Modified:
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
GO

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 : )
ASKER CERTIFIED SOLUTION
Éric Moreau
Senior .Net Consultant
Join our community to see this answer!
Unlock 1 Answer and 19 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 19 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros