Maintenance Plan in SQL 2005

• ramesh-578966

  Grasshopper

  Points: 13

  More actions

  May 26, 2008 at 11:47 pm

  #182777

  Dear friends,

  In SQL 2005 When I tried to create a schedule to backup a SQL 7 compatible database, it was not listed. How to setup a maintenance plan to backup the compatible databases?

  by,

  RRK

• thasteve

  SSCrazy

  Points: 2707

  More actions

  May 27, 2008 at 1:44 am

  #820387

  The Maintenance Plans in Sql Server 2005 only support compatibility level 80 or higher

• Deepak-405225

  SSCertifiable

  Points: 6120

  More actions

  May 27, 2008 at 4:04 am

  #820432

  Your only option is to use T-Sql query to backup the database,

  Backup database dbname to disk='Path\filename.bak'

  [font="Verdana"]- Deepak[/font]