it is possible to take sql server2000 database backup on another machine''s disc.

• Papillon

  Hall of Fame

  Points: 3303

  More actions

  July 25, 2005 at 2:41 am

  #68166

  Hello friends

  Can anybody knows,it is possible to take sql server2000 database backup on another machine's disc.

  I normally take backup on the disc of same machine where my database server is but if i want to take backup to another machine disc then that will possible???

  T.I.A

  Shashank

  ---

  Regards,

  Papillon

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  July 25, 2005 at 7:37 am

  #576759

  Yes, it is. There are some pre-requisites, however. They are listed in the following article:

  HowTo: Backup to UNC name using Database Maintenance Wizard (555128)

  K. Brian Kelley
  @kbriankelley