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?
--
PeteCresswell

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


(PeteCresswell) wrote:
> 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?