Not really familiar with MS SQL Server, but I did figure out how to manually backup a database locally:
In SQL Server 2005 ( SP2 ) using MS SQL Server Management Studio :
I navigate to
Right click on master then:
Tasks->Back Up->Back up to:
I can then backup the master ( as well as one other db ) to a RAID 5 drive array. I am using Retrospect for my backup agent, and I have it copy the folder that the backups are in once a night to a tape drive.
At this point I have to manually do the backup in SQL Server, as I am not sure how to schedule the backup to run? I just want it to run once every evening. Can this be done in Microsoft SQL Server Management Studio, or does this have to be scripted somehow?