Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
backup SQL Server 2000 database while in use
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