I have a verly large .bak file (180 GB) which was stored in Microsoft SQL Server 20开发者_运维技巧08 and I have to restore it. I first installed Microsoft SQL Server 2008 Express and tried to restore it in MS SQL management studio express but it didn't work because there is a size limit. Does anybody know a method how i can restore the file? Its the first time I work with Microsoft SQL and I have no clue what to do. Its really urgend and I would be really helpful for any help! Thanks a lot!
Umutos
You need a full SQL Server installation. With that, and if you have enough diskspace, the restore will work, although it will take some time. As you noted yourself, there is a 4 GB size limit on SQL Server Express, so you cannot use that.
精彩评论