Shulou(Shulou.com)06/01 Report--

In order to improve the performance and security of SQL, No. 2 upgraded the SQL 2008 SP4 patch to the customer, and everything went smoothly during the upgrade process. However, after restarting the server, it was found that the SQL service could not be started, and the event log raised this error:

The script-level upgrade of the database 'master' failed because the upgrade step' sqlagent100_msdb_upgrade.sql' encountered error 598 (status 1, severity 25).

Try to restore the template MASTER database, repair installation, upgrade repair can not be solved, then find a solution on the Internet, found that added in the SQL startup parameters;-T902 parameter can start SQL, and can successfully log in to SMSS, the steps are as follows:

Enable trace flag 902 on the instance of SQL Server 2008 R2. To do this, follow these steps:

Open SQL Server Configuration Manager.

In SQL Server Configuration Manager, click SQL Server Services.

Double-click the SQL Serverservice.

In the SQL Server Properties dialog box, click the Advanced tab.

On click the Advanced tab, locate the Startup Parameters item.

Add;-T902 to the end of the existing string value, and then click OK.

Right-click the SQL Serverservice, and then click Start.

If the SQL Server Agent service is running, right-click the SQL Server Agent service, and then click Stop.

Open SQL Server Management Studio, and then connect to the instance of SQL Server 2008 R2.

Run the following statements:

EXEC sp_configure 'show advanced', 1

RECONFIGURE with override

EXEC sp_configure 'allow updates', 0

RECONFIGURE with override

EXEC sp_configure 'Agent XPs', 1

RECONFIGURE with override

GO

In SQL Server Configuration Manager, right-click the SQL Serverservice, and then click Stop.

Remove trace flag 902 on the instance of SQL Server 2008 R2. To do this, delete;-T902 from the string value that you updated in step 1f.

Right-click the SQL Serverservice, and then click Start.

Right-click the SQL Server Agent service, and then click Start.

In SQL Server Management Studio, reconnect to the instance of SQL Server 2008 R2.

In Object Explorer, expand Management, right-click Data Collection, and then click Enable Data Collection.

Note If data collection is already enabled, the Enable Data Collection item is unavailable.

After completing the above steps, start the SQL service and find that the service is still abnormal and try to add it again;-T902 parameter and manually run the sqlagent100_msdb_upgrade.sql script that reported an error, and found that this error was reported in the running result:

Failed to find the directory for the file "D:\ SQLDATA\ temp_MS_AgentSigningCertificate_database.mdf" with operating system error 2 (the system could not find the specified file.) .

Found that the D:\ SQLDATA directory does not exist, so manually set up the SQLDATA directory, and then run the script to complete successfully. Delete "- T902" in the startup parameters, and then restart the service.

Some people's problems are slightly different, and after his operation, he leads to other error messages.

You can see an error message in the event:

Could not allocate space for object 'dbo.#bulkpackage' in database' tempdb'

This is due to the failure of the execution statement due to the small tempdb.

First use;-T902 after restarting SQL Server, make the tempdb file larger. Delete again;-T902. Just restart SQL Server.

-

The following methods seem simpler:

Start the SQL Server service startup tracking flag 902

General command: Net Start MSSQL$InstanceName / T902 if it is the default instance Net Start MSSQLSERVER / T902

C:\ Windows\ system32 > net start MSSQLSERVER / T902

The SQL Server (MSSQLSERVER) service is starting.

The SQL Server (MSSQLSERVER) service was started successfully.

Transferred from:

Http://www.cnblogs.com/kerrycode/p/4877910.html

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.