August 7, 2009 at 4:31 am
Hi all,
I want to take full backup of a database.
To do this I am scheduling a job so that i can maintained daily backup of my production database
Thanks in advance
Regards
Durgesh J
August 7, 2009 at 7:20 am
For simplicity, why dont you create a maintainanence plan for taking backup for all your databases?
August 11, 2009 at 12:38 am
Hi pradeep,
Could u brief me about maintainence plan, bcoz i am new to database administration
Regards
Durgesh
August 11, 2009 at 9:22 am
DURGESH (8/11/2009)
Hi pradeep,Could u brief me about maintainence plan, bcoz i am new to database administration
Regards
Durgesh
expand your server>management>Maintainence Plan. Right click Maintainence plan and select New Maintainance Plan.
Enter the name of the plan. eg. MyBackupPlan
A new toolbox appears on left side of the screen.
Drag Back Up Database Task and bring it on the window right to it.
Right click the dragged object and select EDIT
From the databases drop down, select the databases for which you want to backup.
Check the backup folder mentioned in the textbox. Change the path if you need it.
You have created the maintainance plan by now.
Now go to SQL Sever Agent>Jobs
A job with the same name will appear.
open the properties of the job and click on schedule and create a schedule to run the job at desired interval.
The job will keep on running at the interval u've defined and will backup ur databases.
August 11, 2009 at 11:16 pm
Thanks man
I have created a maintainence plan.
I have one more question. Do you any idea about reading xml file in sql server 2000. I have worked on reading xml data using variable, but now requirement is to read xml file from a specific location.
Looking forward for your reply
Regards
Durgesh
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply