Differential Backup Automation Question

[Apollo21]

Good Day!

On a standard SQL Server 2000 on a Windows 2003 Server.
I have searched and searched, but I would like verification on the following.

Is it possible to set up differential backups through enterprise manager that includes more than one database at a time? I would like a differential backup for all of the databases in that instance, including system databases.

Failing this, might there be another way to accomplish this task, and what would the code look like, if that were the case?

Thank you very much!
Apollo21

 

[ptheriault]

You can create a maintenance plan. Just select Differential backup in the maint plan wizard.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

You can only backup one database at a time with the backup database command.

The maintenance plans will allow you to select all the databases in a single job, but each one will be backed up seperatly.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Apollo21]

OK - I have looked a couple of times since reading your post, but did not find that option in the maint plan. I had looked before. Is it hidden and what screen does it show up on. I am running SQL Server 2000 - maybe that makes a difference - or am I just missing it totally.

????

 

[Apollo21]

Ok - I am the originator of this post. Just in case you come into this and think you have lost it because you can't find what has been indicated. (A differential backup through the Maintenance Plan) - Please look at this website - My problem may have been that I am not using the Enterprise Version just the Standard Edition of SQL Server 2000 (SP3).

http://searchsqlserver.techtarget.c...506_tax301353,00.html?bucket=ETA&topic=301353

Thanks,
Apollo21

 

[SQLBill]

I don't believe you can do differential backups via maintenance plans - you CAN do full backups and transaction log backups.

Your other option is to use the undocumented procedure spMSForEachTable. See FAQ183-4107.

-SQLBill

Posting advice: FAQ481-4875