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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-11-06 : 07:59:50
|
| 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
11752 Posts |
Posted - 2006-11-06 : 09:04:50
|
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 |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-06 : 09:13:48
|
| And network speed, if backing up on different machine.Also type of backup is important. Full backup, differential, or incremental? Log shipping?Peter LarssonHelsingborg, Sweden |
|
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-11-08 : 00:39:27
|
| "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 memoryits me monty |
|
|
|
|
|
|
Backup time in SQL 2005