Backing Up SQL Server DB?

[(PeteCresswell)]

Just installed a product called MyMovies (looks like a movie
enthusiasts wet dream so far.... try it if you're anywhere near
serious about your movie collection).

It seems to store it's information in a SQL Server DB - at least
the install process installed some version or another of SQL
Server on my XP box.

The application has a menu item for creating a manual backup of
the data, but I know in my heart that when it comes time to
re-image my PC I'm not going to think of that.

So...

Is there a way for me to automagically back up that SQL Server DB
once I figure out where it lives?

I've got a file copy backup utility that runs a few times per day
("SecondCopy").

Is there any hope for automating backups of that DB - or, at
least, the data within?

 

[Tester]

First try this article:

<http://msdn.microsoft.com/en-us/library/ms191239.aspx>

Are you sure you are using MS Sql Server? The reason I am asking is
because there is also MySql - an open source program widely used in
php/CMS and other applications.

The link I have given is for MS SQL server.

hth