开发者

SQL Server 2008 SP1 takes a long time to restore database

开发者 https://www.devze.com 2023-01-08 02:19 出处:网络
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) t

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

精彩评论

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