Marcelo Giovane Silva: Microsoft SQL Server 2005 Enterprise Download, Tecnologia, Gatas, Games,Musica, Filmes tudo em um só lugar!

Nome: SQL Server 2005
Fabricante: Microsoft
Sistema Operacional: Windows 2000/XP/Vista
Lancamento: 2006
Site: http://www.microsoft.com/brasil/servidores/sql/2005/editions/enterprise/default.mspx
Descricao:

O SQL Server 2005 Enterprise Edition é escalonável aos níveis de desempenho necessários para suportar o OLTP (Online Transaction Processing), análises de dados altamente complexas, sistemas de data warehousing e sites corporativos. Com capacidades abrangentes de business intelligence, capacidades analíticas robustas e recursos de alta disponibilidade tais como a clusterização de failover e o espelhamento de banco de dados (database mirroring), o SQL Server Enterprise pode manipular as mais críticas cargas de trabalho empresariais.

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.