![]() Just run this in a query against the database. SELECT SERVERPROPERTY('ResourceVersion') How to check the version of the resourcedatabase on the running server is done with this command The 'from_msx' error should indicate that the mssqlsystemresource1.mdf does not contain this column, hence this one is an older version that the one included on SP2 or SP1. The other copy of the file has the same date as the one that comes with Sqlserver 2005 default. The one located in the "wrong" directory is the one that SP2 "upgraded". One in the default data catalogue with the master.mdf file, and one in a totally different catalogue. On this particular database there is actually 2 such files on the disk. I have the same issue, and having studied the problem a bit it seems that the wrong mssqlsystemresource1.mdf is upgraded. Another install with the refreshed SP2 installed before any maintenance plans were created is working correctly.Īt this point, SP2 has broken our Maintenance Plans on this server. 0, but we still cannot view or create maintenance plans without getting the error. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB933508_sqlrun_Įrror Description : MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: m:\DATA\mssqlsystemresource1.ldf. Product : SQL Server Database Services 2005 (MSSQLSERVER) I'm logged on as a member of the local administrators group, and as a system administrator in SQL Server. We also tried to run hotfix 3050, which resulted in a status of Failure for MSSQLSERVER, with the log indicating that it cannot rename mssqlsystemresource1.ldf. The copy of SQLServer2005SP2-KB921896-圆4-ENU.exe that we ran was the version. What in the world happened to all of my maintenance plans? This has been working for months. () An exception occured while executing a Transact-SQL statement or batch. ![]() Additional Information: Failed to retrieve data for this request. At the end when trying to save the plan I get this error: So I thought I would try creating a new Maintenance Plan using the wizard to see what happens. ![]() After installing SP2 for SQL 2005, when I click on "Maintenance Plans" in the management studio I get the following error:įailed to retrieve data for this request.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |