Skip to main content

Posts

Showing posts from April, 2016

Error during setting SQL Maintenance plan wizard setting

Problem Getting Error during setting SQL Maintenance plan wizard setting. " Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)" Solution : This type of error comes due to t the unregistered COM in dts.dll which is located in in command line change directory and path of dll file is  C:\Program Files\Microsoft SQL Server\100\DTS\Bin You can run the following from the command line to resolve this error: REGSVR32.EXE dts.dll Then you need to disconnect from management studio and reconnect, it again then set SQL Maintenance plan wizard again it should work. I hope this will solve to come out from your troubleshooting.

How to handle disk space issue on C drive

Mostly we face space issue in C drive . How to handle disk space issue on C drive? Following are the steps you can use to free some space in c drive. 1. Go to event viewer and clean all logs. 2. Use disk cleanup properties on c drive to clean unwanted logs. 3. Clean CBS log file at C:\Windows\Logs\CBS folder. 4. Go to %userprofile%\desktop folder and transfer all files to other drives. 5. Set virtual memory to other drive instead of more on c drive. 6. Uninstall unwanted program from control panel ->Program and features. 7. Clean temporary folder from internet explorer. 8. You can use ccleaner software to clean logs. 9. Empty Recycle bin folder. 10. Find duplicate files and delete it.