<div>
Here's a Microsoft tutorial for &quot;Setting up a Maintenance Plan to Backup Databases&quot;<br />
<br />
<a href="http://technet.microsoft.com/en-us/sqlserver/dd430301.aspx" rel="ugc">http://technet.microsoft.com/en-us/sqlserver/dd430301.aspx</a><br />
<br />
and documentation:<br />
<br />
<a href="http://technet.microsoft.com/en-us/library/ms189647(v=sql.100).aspx" rel="ugc">http://technet.microsoft.com/en-us/library/ms189647(v=sql.100).aspx</a>
</div>


<div>
You could do the above things or you could use <a href="http://ola.halengren.com" rel="ugc">http://ola.halengren.com</a>&nbsp;solution. &nbsp;This is a quick solution that you could get backups running pretty quickly without cost.
</div>


<div>
<div class="content wysiwyg-content">
I need to know if there is a way on the sql server 2008 management studio for me to create a backup plan that will backup multiple databases at once. &nbsp;Currently I have a quote out for backup exec but that is about 2-3 months before I can get approval and implement it.<br />
<br />
<br />
if there is no way, howabout me simply duplicating the backup plan for each db?
</div>
</div>


I need to know if there is a way on the sql server 2008 management studio for me to create a backup plan that will backup multiple databases at once.  Currently I have a quote out for backup exec but that is about 2-3 months before I can get approval and implement it.


if there is no way, howabout me simply duplicating the backup plan for each db?

Here&#39;s a Microsoft tutorial for &quot;Setting up a Maintenance Plan to Backup Databases&quot;

http://technet.microsoft.com/en-us/sqlserver/dd430301.aspx

and documentation:

http://technet.microsoft.com/en-us/library/ms189647(v=sql.100).aspx

You could do the above things or you could use http://ola.halengren.com solution.  This is a quick solution that you could get backups running pretty quickly without cost.

backup multiple sql server 2008 r2 databases at once

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.