• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 20. Exploring Access Data Projec... > Backing Up and Restoring Databases

Backing Up and Restoring Databases

Unlike Jet databases, which you back up by a manual copying process, ADP have a built-in snapshot copy process. The best feature of the ADP backup process is that you don't need exclusive access to the database; you can generate a backup while you and other users are connected to the database.

Tip from

Use SQL Server Enterprise Manager to back up large databases to tape manually or automatically. Access's backup and restore features are limited to creating conventional disk files on fixed or removable media. If you intend to back up to a CD-R or CD-RW drive, make a fixed-disk copy and then burn the CD-ROM from the disk copy.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint