Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all

I have my records in access files..now i need to take a backup on a specified date (selected by the user at front end)automatically..
I have to develop one tool which will save the file name and date specified for backup in database table..then depending on date it should automatically take the backup without any manual interference...
the file should save in zip format

please tell me how to do it..
Posted
Comments
[no name] 17-Oct-12 7:00am    
Read the date from your database, compare the dates, if dates match, copy and zip the file.
[no name] 17-Oct-12 7:06am    
please if u have any piece of code then it will be good for me..i m not getting any idea..i searched google but not getting anything..
any there are more than 20 access file which i have to take backup..

1 solution

CSS
I have only started using SQL Server 2005 Express Edition recently.I also installed Management Studio Express version to manage the database. While testing the database I had came across some question and they are:
Can I upgrade from SQL Server 2005 Express to Workgroup/Standard/Enterprise without loosing the database and its contents.
While I backed up the database, I was permitted to backup only on to my local drive even though I have administrative rights on the system. It would be easy if I could backup to a network drive directly.My question is:Is it possible to backup directly to a network drive rather than backing the database to a local drive and then "copy and paste" it to a network drive.
Windows Scheduler: I have scheduled a daily backup of the database by midnight. I have also written the script to run the backup. But every time the scheduler starts the backup, it asks for the database password. This halts the backup until I come back in the morning and manually enter the password. My question is: is it possible to run an automatic database backup using Windows Scheduler?
I understand that there are 2 types of backups: full and differential backups. My question is: Is it possible to dynamically allocate different names automatically to consecutive backups so that the previous backups are not over written

Thanks for your patience and time.
 
Share this answer
 
Comments
[no name] 17-Oct-12 7:16am    
why u posted this as solution..??

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900