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 |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2002-11-18 : 11:25:46
|
| We ran into a huge bummer. Our Production DB server uses Windows 2000 Server SP2, SQL 2k, SP1. Our QA DB server which hosts about 10 instances was recently upgraded to Advanced Server to let it exploit the 8GB of RAM.To do this you have to boot the server with /pae option in boot.ini.When we did this, we could use the server without any problems. The performance is great. But you try to copy large files/ restore databases from a non advanced server (which does not use /pae switch). NT Restore, SQL Restore from tape and sometimes even plain old file copy does not go through.Upon researching I found that if the old backups have to be used, we have to disable the /pae switch in boot.ini reboot. finish your restore and put back the /pae switch to function as before.Microsoft is still trying to work this problem out, I was in fact wondering if any of the illustrious colleagues have a simpler and more permanent work around on this... |
|
|
|
|
|
Tape Restore Problem on SQL 2K with Advanced Windo