Database Maintenance Plans

• bryan99y

  SSCarpal Tunnel

  Points: 4672

  More actions

  April 19, 2002 at 6:56 am

  #64073

  I have 6 SQL Server 2000 Enterprise Edition Instances on my Development server.

  Since the database names will be the same on all Instances, how can I distinguish the backup files for each. Currently I have them backing up to specific folders, but I would like to append something the backup files that get created by Database Maintenence Plans.

  Any ideas ?

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  April 19, 2002 at 7:13 am

  #427489

  You want all the backups from all instances in one folder?

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter