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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Backup time in SQL 2005
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 11/06/2006 :  07:59:50  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
Morteza writes "Hello,

I am working with 2 servers both OS are MS Windows 2003 and one has SQL Server 2000 Enterprise edition and the other SQL Server 2005 Standard Edition.
I have two fairly huge databases (one in each). The one on SQL 2000 server is about 20GB and the full backup time is less than 15 minutes but the one on SQL 2005 server with about the same size takes 2 hours and half to be backed up.
What possibly am I doing wrong?

Also on these servers, I have 3GB of memory, in which the SQL 2000 server lets me use all but the SQL 2005 server limits me to 2GB and I cannot initialize the rest.



Cybernetic Yak Master

11752 Posts

Posted - 11/06/2006 :  09:04:50  Show Profile  Visit spirit1's Homepage  Reply with Quote
backup time also depends on disk IO speed.

Go with the flow & have fun! Else fight the flow
blog thingie:
Go to Top of Page

Patron Saint of Lost Yaks

30421 Posts

Posted - 11/06/2006 :  09:13:48  Show Profile  Visit SwePeso's Homepage  Reply with Quote
And network speed, if backing up on different machine.
Also type of backup is important. Full backup, differential, or incremental? Log shipping?

Peter Larsson
Helsingborg, Sweden
Go to Top of Page

Posting Yak Master

130 Posts

Posted - 11/08/2006 :  00:39:27  Show Profile  Reply with Quote
"but the SQL 2005 server limits me to 2GB and I cannot initialize the rest"

log on having admin rights and then in the boot.ini file add PAE\ switch so that you can use required memory

its me monty
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000