469,081 Members | 1,803 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

full database backup

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
2 2099

"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

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.

Similar topics

1 post views Thread by DBA | last post: by
2 posts views Thread by francois1 | last post: by
1 post views Thread by shiju | last post: by
2 posts views Thread by m19peters | last post: by
3 posts views Thread by xeqister | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.