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.
精彩评论