I need to make a daily backup, several times a day, of a database, while that database is being used. The database is sql server 2000.
I would prefer to backup the database using a .bat file with the windows "copy" command. I don't know if this is possible but for the search in google and accoona that i've been making i found out that that is possible with MS SQL Server 2005 only. This is for a client and i wasn't the one who implemented the software solution at his companny, i'm accustomed to use MS Access, which offers no problems backing up the database using a .bat file.
If i can't use a .bat file, how can i make the backup with the database being used and without the user interaction?
My thanks in advanced