Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 Backup multiple Databses with multiple files

Author  Topic 

jay1
Starting Member

17 Posts

Posted - 2010-08-25 : 08:28:13
Hi All,

I want to backup multiple Databases on Daily biases and create a file for each Database and have datetime stamp. I would like the backups to take less space as possible.

Thank you in advance.

Kristen
Test

22859 Posts

Posted - 2010-08-25 : 08:59:24
Use Maintenance Plan (or a Stored Procedure to do the task, such as the one in Tara's Blog - http://weblogs.sqlteam.com/tarad/default.aspx)
Go to Top of Page
   

- Advertisement -