SQL 7/2000 Export Database

• castillr

  Newbie

  Points: 1

  More actions

  January 20, 2003 at 1:10 pm

  #105459

  HI,

  I am an Oracle DBA and new comer to SQL Server. I am trying to do a database export as a backup method. Does anyone have a script they can share. I am looking into scheduling a job on a daily basis..Thanks

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  January 20, 2003 at 2:09 pm

  #446803

  You can create a dts package to export the db, and then schedule from a job.

  For creating a dts package check BOL.