By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,208 Members | 1,592 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,208 IT Pros & Developers. It's quick & easy.

full database backup

P: n/a
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 ?

Thanks in advance
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"newbiegca_sqlsever2000" <ne***************@sbcglobal.net> wrote in message
news:d1**************************@posting.google.c om...
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)

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.
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 ?

Thanks in advance


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
Jul 20 '05 #2

P: n/a

Thanks Simon
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.