Files Are Not Deleted From Recycler Folder

I have encountered an issue today where the drive was filling up. I deleted some old backups from the drive and still there were some hidden files which were taking up space. when i checked, it was the RECYCLER folder. This was keeping some of the very old deleted files, which i had to delete manually and release space to the drive. Here below is the link to the MS site about this and how to delete the contents of this folder.

http://support.microsoft.com/kb/229041

To resolve this issue, delete the files from an MS-DOS prompt. To do this, follow these steps:


1.Click Start, click Run, type cmd.exe in the Open box, and then click OK.

2.Change to the drive and folder where you deleted the files. For example if you deleted a file from the C:\Windows folder, type cd\windows at the C: prompt, and then press ENTER.

3.From that folder type cd recycler, and then press ENTER.

4.From the Recycler folder type dir, and then press ENTER. You may see some UserSID folders where SID is the security ID for each user who deleted files in that folder.

5.Type cd userSID, and then press ENTER.

6.Type del *.*, and then press ENTER. If you receive an error message that indicates some files are open, quit all the programs running on your computer.

7.Type cd.., press ENTER, and then repeat steps 5-7 for each folder in the Recycler folder.

8.Type exit, and then press ENTER.

MvM

Cumulative update package 3 for SQL Server 2008 R2 Service Pack 2

Build 10.50.4266.0 (cumulative update)


This cumulative update package was released on October 15, 2012.

The parent build of this build is 10.50.4263.0.

For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

2754552 http://support.microsoft.com/kb/2754552

Cumulative update package 3 for SQL Server 2008 R2 Service Pack 2

SQL Server 2008 R2 SP2 CU2 fails - sqlagtctr.dll

I have faced isssues with few systems now regarding the DLL 'sqlagtctr.dll'

====== From C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log ======


Final result: The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files.

MSSQL10_50.MYSERVER-sqlagtctr.dll. ---> Microsoft.SqlServer.Configuration.Sco.ScoException: The process cannot access the file 'C:\Windows\system32\perf-MSSQL10_50.MYSERVER-sqlagtctr.dll' because it is being used by another process. ---> System.IO.IOException: The process cannot access the file 'C:\Windows\system32\perf-MSSQL10_50.MYSERVER-sqlagtctr.dll' because it is being used by another process.

MSSQL10_50.MYSERVER-sqlagtctr.dll. ---> Microsoft.SqlServer.Configuration.Sco.ScoException: The process cannot access the file 'C:\Windows\SysWOW64\perf-MSSQL10_50.MYSERVER-sqlagtctr.dll' because it is being used by another process. ---> System.IO.IOException: The process cannot access the file 'C:\Windows\SysWOW64\perf-MSSQL10_50.MYSERVER-sqlagtctr.dll' because it is being used by another process.

With workarounds from Microsoft sites, I have renamed these DLL’s and have completed the upgrade successfully.

http://blogs.msdn.com/b/karthick_pk/archive/2012/07/16/the-process-cannot-access-the-file-c-windows-system32-perf-mssql10-50-mssqlserver-sqlagtctr-dll-because-it-is-being-used-by-another-process.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/06fc5c42-9d5d-4331-a4b9-210559411eee

https://connect.microsoft.com/SQLServer/feedback/details/576412/-the-process-cannot-access-the-file-c-windows-syswow64-perf-mssql10-50-mssqlserver-sqlagtctr-dll-because-it-is-being-used-by-another-process

A similar issue to the one I mentioned above, that might occur with upgrading of cluster resources during SP2 install. (http://msdn.microsoft.com/en-US/library/hh995349(v=sql.15).aspx)


2.2 Setup Might Fail if SQAGTRES.dll Is Locked by Another Process

Issue: A SQL Server setup operation might fail with this error: Upgrading of cluster resource C:\Program Files\Microsoft SQL Server\MSSQL10_50.\MSSQL\Binn\SQAGTRES.DLL on machine failed with Win32Exception. Please look at inner exception for details. The root cause is that C:\Windows\system32\SQAGTRES.DLL is locked by another process and Setup was not able to update it.

Workaround: Rename C:\Windows\system32\SQAGTRES.DLL to a temporary name such as C:\Windows\system32\SQAGTRES_old.DLL, and then select the Retry option on the setup error message. That will allow Setup to continue. After a reboot, you can delete the temporary file C:\Windows\system32\SQAGTRES_old.DLL.

MvM