I was looking to do an automatic SQL Server 2005 backup using SQL Server Express. SQL Server Express 2005 does not offer a built in way to backup automatically. So after doing a fair amount of testing and searching I finally figured out how it could be set up. The solution I use first of makes a local backup copy …