backup the database for every one hour

[prabunewindia]

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

[gusa992000]

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

[prabunewindia]

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

[vivekshrivastava51]

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

[prabunewindia]

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

[Frinavale]

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

[radcaesar]

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.

:)

[prabunewindia]

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.

:)