Win2000 Backup Utility and SQL server

• dtoakley

  SSC Rookie

  Points: 44

  More actions

  August 22, 2002 at 2:10 pm

  #105033

  We recently migrated from Access to SQL Server 2000. In the past we just backed up our Access DBs to a removable network drive by using the Win2000 backup utility to backup the MDB files directly to the drive. We cycled our 5-6 drives with every backup.

  My question is, can we continue to use the Win2000 utility to backup SQL database files directly from our SQL data folder to our network drives, or are their other files and settings that need to be backed up as well?

  Thanks for your help!

  David Oakley

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734418

  More actions

  August 22, 2002 at 3:35 pm

  #435139

  You can if you stop SQL Server. The other alternative is run perform a SQL Backup to a flat file (usually a .bak file) and backup this.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones