sql server (alternate): Question 1

3 GHZ CPU (Intel pentium 4) single cpu + 2 GB Memory + SCSI HDD

Database size 10 GB - How long will full database backup take if the
backup is writing a file to the hard disk (separate hard disk)

Question 2

during this full backup are users and application able to access the
database

for example
a) select records

b) insert , update, delete records

or is the database backup causing the database to be exclusively
locked up ?

[quoted text, click to view]

No idea - just try it and see. You can backup to multiple files/devices at
once if you need to speed things up, although this will probably only help
if the devices are physically independent drives. See "Using Multiple Media
or Devices" in Books Online.

[quoted text, click to view]

A backup is an online operation, and users can continue to access the
database, including modifying data, while the backup is running (see "Backup
Restrictions" in Books Online). You might also want to review the whole
"Backing Up and Restoring Databases" topic for more detailed information on
backups, recovery models etc.

Simon

Thanks Simon


*** Sent via Developersdex http://www.developersdex.com ***