开发者

how to restore very large .bak file (180 GB) in SQL Server 2008

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜