Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a Microsoft SQL Server 2005 DB server. In the DB server, I have around 250 user databases. I have to take a back up of all these databases. Since, manually taking backup consumes lot of time, I am looking for a Batch script or DB script which will automatically take the backup of all the 250 databases. Can anyone please help on this?

This question came from our site for professional and enthusiast programmers.

Do you have to do this once, or on a regular basis?
–
Jon SeigelJul 26 '12 at 13:23

Are all the backups using the same recovery model? Automating backups are nice but if the backups do not meet your recovery needs for your user's data, the backup means nothing.
–
Shawn MeltonJul 30 '12 at 7:25

Hi Yaqub, this isn't quite what we would call a full answer. Is there any way you can expound on this for us so that it provides a little more context for in the future? Maybe some detail on what you mean by "properly configured SQL job"?
–
jcolebrand♦Jul 26 '12 at 18:24

Hi Emito and welcome to Stack Exchange. We generally ask that people provide definition on their link so that (heaven forbid) when the link rots, the context of the link stays. Maybe you could paste in the parts you think are pertinent, keeping your link for attribution?
–
jcolebrand♦Jul 26 '12 at 18:22

Hi Yaroslav and welcome to Stack Exchange. We generally ask that people provide definition on their link so that (heaven forbid) when the link rots, the context of the link stays. Maybe you could paste in the parts you think are pertinent, keeping your link for attribution?
–
jcolebrand♦Jul 26 '12 at 18:23