开发者

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

开发者 https://www.devze.com 2022-12-28 08:32 出处:网络
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

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

精彩评论

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