Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 What SQL Backup time depends on

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-01-24 : 08:40:26
selma can writes "Hi,
I wonder how much SQL backup time depends on tape unit,CPU speed,memory size, server load,etc. I can guest that all of them affect that time.
Thanks from now"

JamesH
Posting Yak Master

149 Posts

Posted - 2003-01-27 : 08:41:14
It sounds like you're backing up directly to tape and it might be causing some performance problems. If so, I would advise that you backup to disk and then copy that backup to tape. Of course all of the things that you listed affect backup and overall sql performance as hardware always does. If you're having a particular problem just ask the question and someone can help you.

Thanks,

JamesH.

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-01-27 : 17:00:14
[url]http://www.sql-server-performance.com/backup_restore_tuning.asp[/url]

Go to Top of Page
   

- Advertisement -