Microsoft SQL Server is a very powerful and robust database application. It is the premiere choice of most large organizations who utilize a database solution. In most cases the data being stored in these databases are mission critical and coming up with a disaster recovery plan is top
priority.
There are many parts to a proper disaster recovery plan but in this guide I am going to go over setting up SQL Server backups. By backups, I mean using SQL Servers built in backup system. This is called creating a SQL Server 2005 Maintenance Plan. I'm going to strongly recommend that you install the SQL Server 2005 Service Pack 1 first. There are a lot of improvements in this Service Pack and it would be beneficial to have it loaded.
The first step in creating a Maintenance Plan is connecting to the database server with Management Studio.
Once connected to the server, go under the Management folder, then right click the Maintenance Plan folder in object explorer and choose new Maintenance Plan. Enter the name for your Maintenance Plan and hit okay. Now a Maintenance Plan design panel will appear on the right, and a toolbox with available Maintenance Plan Tasks will be displayed on the left.
Now we need to create a task for this SQL Server 2005 Maintenance Plan to execute. Go ahead and drag and drop the "Backup database Task" from the toolbox to the design panel. Then double click the item and you will be presented with several options.
Disclaimer: Ultimate-War3z does not host any illegal files on its server. Ultimate-War3z only indexes and
links to content provided by other websites. To view our DMCA Policy Click Here.
07-02-2009, 11:27 PM
SQL 2005 enterprise
-->
Linear Mode
