script to backup all userdatabases

• sivark1

  SSCrazy

  Points: 2654

  More actions

  November 10, 2009 at 12:12 am

  #211950

  Hi,

  Pls send t-sql script to take backup for all user dataases both in sql 2000 & 2005

  Thanks in advance

• Animal Magic

  SSChampion

  Points: 13964

  More actions

  November 10, 2009 at 2:27 am

  #1077122

  have a look in the scripts folder for yourself and see what suits you best.

  http://www.sqlservercentral.com/Scripts/

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 10, 2009 at 7:15 am

  #1077224

  You can also visit Ola Hallengren's site[/url] he has a set of database maintenance scripts that include backups.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question