DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: sql server backup

  1. #1
    rich Guest

    sql server backup


    when i backup a database to tape or other media, is there a lock on the database
    when the backup process is running? can other apps like a dts package read
    and/or write to table(s) of a database that is being backed-up at the same
    time? thanks in advance.

  2. #2
    Michael Levy Guest

    Re: sql server backup

    SQL Server implements a hot backup. Users can access and manipulate the
    database while the back is proceeding.

    -Mike
    --
    Michael Levy MCDBA, MCSD, MCT
    michaell@gasullivan.com



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center