re auto backup ms sql server express

• ltoso

  SSC Eights!

  Points: 852

  More actions

  June 4, 2008 at 6:29 am

  #191311

  Hi,

  i am running ms sql server express 2005 on our shared hosting server, which have databases of lot of hosting accounts.

  i would like to know is there a way by which we can automatically backup the databsases on the server.

  thanx

  ltoso

• the__t

  Hall of Fame

  Points: 3260

  More actions

  June 4, 2008 at 8:43 am

  #824225

  Since Express does not come with the Agent, you need to use a work around with Task Scheduler, if you want this to be automated.

  Please see here:

  http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=ExpressBackups&referringTitle=Home

  "Got no time for the jibba jabba!"
  -B.A. Baracus