By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,994 Members | 2,036 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,994 IT Pros & Developers. It's quick & easy.

backup the database for every one hour

prabunewindia
100+
P: 199
hi friends,
i want backup the database for every one hour.
anyone plz give me the code for that.
i don't know anythink about that
plz help me
Prabu
Apr 20 '07 #1
Share this Question
Share on Google+
7 Replies


P: 6
Firstly.. which database?? Oracle?? Sql Server??? MySql???

And then i suggest to post the question in the appropiate database forum. As usually the database backup is generated not by .net or java code but by the dababase program (Oracle Console Manager, SQL Server Management,...).
Apr 20 '07 #2

prabunewindia
100+
P: 199
i am using sqlServer
thank for ur guidence
Prabu
Firstly.. which database?? Oracle?? Sql Server??? MySql???

And then i suggest to post the question in the appropiate database forum. As usually the database backup is generated not by .net or java code but by the dababase program (Oracle Console Manager, SQL Server Management,...).
Apr 20 '07 #3

P: 18
i am using sqlServer
thank for ur guidence
Prabu
hi , this is vivek
if u want to take backup of the database in sql server do that things
-- first open the sql enterprises manager --> then go to that folder whose backup u want to create ---> right click on it --> select all task--> export data -->
and do according to given things
by this u can take backup of ur database anytime .
i hope this will help u .. bye
Apr 20 '07 #4

prabunewindia
100+
P: 199
friend,
i want to take back while the application is running
i need the code
Prabu
hi , this is vivek
if u want to take backup of the database in sql server do that things
-- first open the sql enterprises manager --> then go to that folder whose backup u want to create ---> right click on it --> select all task--> export data -->
and do according to given things
by this u can take backup of ur database anytime .
i hope this will help u .. bye
Apr 20 '07 #5

Frinavale
Expert Mod 5K+
P: 9,731
friend,
i want to take back while the application is running
i need the code
Prabu
Hi Prabu!

Do you need to do this through your program or can back up be done through the services that the SqlServer comes with. An SqlServer can be configured to automatically back up at a given time.

-Frinny
Apr 20 '07 #6

radcaesar
Expert 100+
P: 759
Create a windows control
Use System.Timers

Check the system time every second using the "OnElapsedTime" event of the Timer class

When the time ticks, Execute the query which performs the backup.

(The windows control will be installed and run on the system like watch dog to watch the time)

RE me if u have any issues.

:)
Apr 20 '07 #7

prabunewindia
100+
P: 199
i am using ASP.NET. plz give me the query for that.
i know nothing in this. database should be backup for every 1 hr.
i want it in code.
plz guide
prabu

Create a windows control
Use System.Timers

Check the system time every second using the "OnElapsedTime" event of the Timer class

When the time ticks, Execute the query which performs the backup.

(The windows control will be installed and run on the system like watch dog to watch the time)

RE me if u have any issues.

:)
Apr 21 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.