 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Windows Forum / Virtual PC / April 2008Failed to restore a big database on SQL Server 2005 in Virtual Pc
Has anyone who restored a big database in Virtual PC 2007? I installed SQL 2005 Standard Edition on Windows XP SP2 in Virtual PC 2007. The size of the back up file of the database that I wanted to restore is more than 5.5GB. (about 6GB) On a Local PC (I mean, physical.), it was successful to restore that back up file. On virtual PC, however, it failed. Then I thought I needed to make the virtual hard disk that VPC2007 was using fixed , not automatically expanding. And I did it. Failed to restore though. (ofcourse the file system is NTFS) what's the problem with this? Did I somthing wrong?? plz, help me. Thanks advance. Albert. >Has anyone who restored a big database in Virtual PC 2007? > [quoted text clipped - 12 lines] > >what's the problem with this? Did I somthing wrong?? How did you make the backup file available to the guest? I would *not* use the VPC "Shared Folders" for files of this size, it is better to use the normal network shares and then copy from wherever the file is located to the guest's own hard disk using the network inside the guest. Once the file is available on the guest disk then the restore in SQLServer should work fine. >>Has anyone who restored a big database in Virtual PC 2007? >> [quoted text clipped - 23 lines] > Once the file is available on the guest disk then the restore in > SQLServer should work fine. I can confirm this issue. This has been driving me crazy for weeks. The problem is indeed using VPC Shared Folders. Apparently there is a 4 GB size limit with Shared Folders. Using real networking works fine. The problem is that a SQL Server .bak file (DB backup) over 4 GB gets truncated/corrupted when trying to restore onto SQL Server 2005. I was using Shared Folders, and just now tried using real networking to copy the .bak file onto my Server 2003/SQL Server 2005 VHD, then restored it into SQL Server 2005 . It works fine. I joined this group hoping to find a solution to this very issue! >>>Has anyone who restored a big database in Virtual PC 2007? >>> [quoted text clipped - 35 lines] > >I joined this group hoping to find a solution to this very issue! Glad you succeeded! VPC shared folers is just barely usable for small files.... Bo Berglund |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.