i've searched the forums here & found a few question/answers that speak a little to my question, but not completely. i perform basic SQL administration on several 2005 & 2008 SQL servers but i encountered my first vendor-supplied SQL Server Express 2008 server today. i need to set up full nightly backups & daily hourly transaction logs for the application databases on this server. after much reading, i realize that Express is a desktop version of the full-blown SQL (2005 or 2008) that i'm more accustomed to. so i also realize that i do not have access to Maintenance Plans or SQL Server Agent/Jobs that i would normally create my bak's & trn's from. i was able to find a post here that mentioned using sqlcmd<enter>backup database master to disk = 'c:\program files\backup\master.bak' to get a full backup - this did get me through an initial backup yesterday since the system has never had a backup run.
i also found a couple of articles on Microsoft's site (Library Article & Support Article) that cover how to get backups using TSQL & Windows Scheduled Task. The Microsoft Support article is probably more of what i'm looking to do but it's also more than i can understand at this point - i've never really done any scripting. is there anyone willing to take the time to help me figure out how i can create the Stored Procedure & the Batch File that will allow me to get a full nightly backup of Database1 & Database2 as well as hourly transaction logs from 5a-9p daily for those 2 databases? i don't need backups of any other databases such as master, etc. i just cannot understand all the scripting that is going on in the Support article in order to pull out or modify to my specific needs.
i would appreciate any help anyone could give me, but also understand this may be too large a request.
i also found a couple of articles on Microsoft's site (Library Article & Support Article) that cover how to get backups using TSQL & Windows Scheduled Task. The Microsoft Support article is probably more of what i'm looking to do but it's also more than i can understand at this point - i've never really done any scripting. is there anyone willing to take the time to help me figure out how i can create the Stored Procedure & the Batch File that will allow me to get a full nightly backup of Database1 & Database2 as well as hourly transaction logs from 5a-9p daily for those 2 databases? i don't need backups of any other databases such as master, etc. i just cannot understand all the scripting that is going on in the Support article in order to pull out or modify to my specific needs.
i would appreciate any help anyone could give me, but also understand this may be too large a request.