Article Summary
DBA Related
Workaround(s)
EarnWrite
DBA Site
Please ask and share the problems and solutions via www.msqlserver.com
Latest Article :
Difference between a Cumulative Update and Service Pack for SQL Server
Cumulative Update
Cumulative Updates are primarily released for hotfix purposes.
Service Pack
Service Pack is they include actual changes or new enhancing features.
It is being used by another process
The process cannot access the file 'C:WindowsSysWOW64perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll' because it is being used by another process
| 1 3 User(s) can reproduce this bug | |||||||||||||
Windows 7 x64, SQL 2008 SP1 CU8 upgrade to SQL 2008 R2 RTM. i get this error message everytime:
The following error has occurred:
The process cannot access the file 'C:WindowsSysWOW64perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll' because it is being used by another process.
Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1&EvtType=0x60797DC7%25400x24C2C4E7
I tried to use process explorer to determine what has this locked, but i am starting to suspect some type of redirection is not occurring?
WORKAROUND :-
1) Stop SQL Services.
2) Rename the file
Tuesday, December 13, 2011
Delete Secondary File
To shrink a data or log file
- In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.
- Expand Databases and then right-click the database that you want to shrink.
- Point to Tasks, point to Shrink, and then click Files.
- Select the file type and file name.
- Optionally, select the Release unused space check box.Selecting this option causes any unused space in the file to be released to the operating system and shrinks the file to the last allocated extent. This reduces the file size without moving any data.
- Optionally, select the Reorganize files before releasing unused space check box. If this is selected, the Shrink file to value must be specified. By default, the option is cleared.Selecting this option causes any unused space in the file to be released to the operating system and tries to relocate rows to unallocated pages.
- Optionally, enter the maximum percentage of free space to be left in the database file after the database has been shrunk. Permissible values are between 0 and 99. This option is only available when Reorganize files before releasing unused space is enabled.
- Optionally, select the Empty file by migrating the data to other files in the same filegroup check box.Selecting this option moves all data from the specified file to other files in the filegroup. The empty file can then be deleted. This option is the same as executing DBCC SHRINKFILE with the EMPTYFILE option.
- Click OK.
DBA
pradyothana has a website at www.msqlserver.com
Article Tags
Related Articles
No related articles were found.
More Articles By pradyothana
DBA Site
by pradyothana | in Education | 152 Views
DBA Related
Add a Comment
You must Login to enter comments.
Categories
- Arts, Crafts and Hobbies
- Automotive
- Business and Profession
- Computers
- Education
- Events and Holidays
- Family
- Fashion
- Food
- Games and Entertainment
- Health and Nutrition
- Home
- Internet
- Law and Government
- Media
- Money
- People, Places and Culture
- Plants and Animals
- Relationships
- Religion
- Science
- Sports and Recreation
- Earnwrite Help
Renamed: OLD_perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll
and was able to 'Retry' the Repair SQL 2008 R2 installation and continue.
This works.