October 6, 2009 at 12:31 am
Hi all,
i am using sql servwr 2005
how to backup the database every day 1Am.
it will take the autamatically i mean job schedue
please help me
October 6, 2009 at 1:36 am
polo.csit (10/6/2009)
Hi all,i am using sql servwr 2005
how to backup the database every day 1Am.
it will take the autamatically i mean job schedue
please help me
In Management Studio, connect to your server, go to management, you will see maintenance plans, right click on maintenance plan wizard, and go through the wizard selecting the database you want to backup and select the time that you want it to happen.
if this isnt clear enough for you let me know
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 6, 2009 at 6:50 am
You can also do it without the maintenance plans.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply