Hello readers i have come with the new Sql server Blogs for interesting things is "Auto BackUp Database Maintenance Plans" every organization or small farms no time to Backup his database every manually so here is MS Sql Server give you a one Maintenance Plane facility to create a Auto backup plane for as suite for your Comfortable time for back up automatically and store specific location in his hard drive.
click on Ok Button after configuration is finished and then save again the back up plan
Go to the Sqlserver agents one Job is Automatically create with the name of your back up plane.
to confirm the job is working fine to right click on job and the click on "Start job at step" here one porcess window is open and see the progress it's done success check on back up folder backup file created with .bak extension.
in this blog i briefly explain about the how to create and maintain the Sql serve auto backup maintenance plane and configure for you suite.so latest start with the Sql server login.
Login into sql server management studio using the User name and password.
expand the folder Management >> Maintenance Plans
this view like this and then
Right click on Maintenance plans and select New Maintenance Plans
view like this
it's open a new window for give a Maintance plan name so give the perticulat name and then click ok to continue i.e, i give the name "AutoBackup"
next window is open for configure the Autobackup plane configure and create new a sub plan for the autobackup lane currently i am no create sub plan, i only the default plan configure the time and day occurrences, the window look like this view
next i configure the Subplan_1 job schedule for the Database Backup occurs every day on 10:00pm for specific location in my local Storage.
click on ok button after set all the criteria, in this schedule i select the type Recurring for my plan and the go to next .
complete this configuration select the save button to save the Autobackup plan. save plan display in left pan window under "Maintenance plan" window here is right click on Autobackup and select execute to confirm maintenance plan is work fine without error.
Next step is open the Toolbox from view menu and and view the list of component in the toolbox and locate the "Backup Database Task" and select this tool and drag and drop on the subplan_1 area.
Drag and drop the tool on right pan area
Right click on Back Up Database Task and Edit the Plane and configure as you suit.
in this window you can configure the following things for recommended .
- Connection
- Back up Type
- Database
- Back Up Folder to store the back up file
- Back Up file Extension (.bak)
click on Ok Button after configuration is finished and then save again the back up plan
Go to the Sqlserver agents one Job is Automatically create with the name of your back up plane.
to confirm the job is working fine to right click on job and the click on "Start job at step" here one porcess window is open and see the progress it's done success check on back up folder backup file created with .bak extension.
so i complete my post now and i come with another post later,any help regarding this post and any query please leave the comment or contact me via email,i try to solve your issue as soon as possible
Thanks
Krunal patel
(Software Developer)
My Popular post click on Link to view
- Introduction of MS SQL Server
- Create a Database in MS Sql Server 2008 R2
- Create a View in MS Sql Server 2008 R2
- Create a New Database User In Sql Server 2008 R2
- Create a New Stored Procedure in Sql Server Step by Step
- Create a Database Backup in Sql Server 2008 R2
- Restore Database in Sql Server 2008 R2
- Sql Server 2008 R2 Connect Via Internet
No comments:
Post a Comment