SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

AskSQLTeam
Ask SQLTeam Question

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

Thanks,

Morteza"

spirit1
Cybernetic Yak Master

Slovenia
11749 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: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 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

monty
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  
 New 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.03 seconds. Powered By: Snitz Forums 2000