开发者

SQL Server 2008 SP1 takes a long time to restore database

I'm using SQL Server 2008 SP1. It takes a long time when restoring the data开发者_如何学Pythonbase from backup file. Following the Microsoft support website (http://support.microsoft.com/kb/975089) that was a bug of SQL Server 2005 & 2008 and they released a update package which named "Cumulative update package 5 for SQL Server 2008 Service Pack 1". I installed the update package but nothing happened. SQL Server is restoring the database until now and I can not stop restoring process.

Does anybody give me any advices?


Thank Ed Harper for your useful advice. I run the following statement to Enable trace flag 4133:

DBCC TRACEON (4133, -1);

Pay special attetion to "-1" parameter to make type of flag is globalization.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜