August 22, 2002 at 2:10 pm
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
August 22, 2002 at 3:35 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy