在进行自动数据库备份时需要帮助 [英] Need help in taking automatic database backup

问题描述

大家好

我的记录保存在访问文件中.现在我需要在指定日期(由前端用户选择)自动进行备份..
我必须开发一种工具，该工具会将指定备份的文件名和日期保存在数据库表中.然后，根据日期，它应该自动进行备份，而无需任何手动干预...
该文件应以zip格式保存

请告诉我该怎么做..

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..

推荐答案

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.

这篇关于在进行自动数据库备份时需要帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！