trigger for take database backup

Question

0.00/5 (No votes)

See more:

Hello..

i work on database task. i have to take database backup at all day 12:00 AM.
what should i do for it ?
any trigger can work ? or any other way ?

Posted 27-May-13 21:05pm

Archit Patel

Add a Solution

Comments

Maciej Los 28-May-13 3:29am

Have you tried anything?
Where are you stuck?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Aarti Meswania · Accepted Answer · 2013-05-27T21:09:00

Solution 1

you should use SQL Job for this task
visit page for details...
http://blogs.msdn.com/b/sqlagent/archive/2010/10/12/create-a-database-backup-job-using-sql-server-management-studio.aspx[^]
Happy Coding!
:)

Posted 27-May-13 21:09pm

Aarti Meswania

Comments

[no name] 28-May-13 3:13am

thanks good one 5*

Aarti Meswania 28-May-13 3:21am

you should install full sql enterprise or Developer edition (which support sql agent service)
or
you can do with Window service
or
bat file in schedule

Aarti Meswania 28-May-13 3:26am

Thnks for rating,
Glad to help you! :)

[no name] 28-May-13 3:16am

but one problem it server agent in my sql server 2005 management studio for that what should i do ?

Maciej Los 28-May-13 3:31am

Install SSMS: http://www.microsoft.com/en-us/download/details.aspx?id=8961[^]

Maciej Los 28-May-13 3:32am

Good work, Aarti!
+5

Aarti Meswania 28-May-13 3:41am

Thank you! :)