Technical Fixes
RSS icon Email icon Home icon
  • SQL – The Log File Is Full

    Posted on May 19th, 2009 Matt Parkinson No comments

    When backing up a a SQL database with Symantec Backup Exec I was seeing the error “The log file for database is full. Back up the transaction log for the database to free up some log space.” With backup exec to fix this you can run a backup of the SQL database and under the SQL options set the “Backup method for databases” to “LOG – Back Up Transaction Log.” However you can also clear this error by using the Microsoft SQL Query Analyzer and running the following query:

    backup log db_name with truncate_only
    go
    dbcc shrinkfile (db_name_log,0)
    go

  • CD/DVD Drive is Missing or not Recognised

    Posted on May 10th, 2009 Matt Parkinson 1 comment

    Recently when I was trying to fix someones computer I noticed that the the CD drive was missing from Windows and the user was also reporting that they had not been able to use it for a while. I looked at device manager and found that the CD drive had an error. Upon opening the device up it was reporting an error that “Windows could not load the device driver for this hardware. The driver may be corrupted or missing.” After a bit of research I found that the way to fix this was by removing the upper and lower filters. The reason for this is that other programs can corrupt these 2 registry entries. One of the common causes reported was an older version of iTunes which modified these values but other software that interacts with the CD drive can also cause this. To fix this problem please follow the steps below:

    1. Go to start and then run.
    2. Type in ‘regedit’ and press enter.
    3. Locate the registry key ‘HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Class\{4D36E965-E325-11CE-BFC1-08002BE10318}’.
    4. In the right hand pane click ‘UpperFilters’ and press delete.
    5. In the right hand pane click ‘LowerFilters’ and press delete.
    6. Exit the registry editor and restart the computer.

    Before you make these changes you should backup the registry entries that you are about to delete. This can be done by right clicking the registry key and going to export. It is possible that only one of the registry entries will be present so just delete the entries that are present. Upon restarting the computer the values will be automatically re-created with the default values and your CD drive should be working again.

  • Runas in Vista & Server 2008

    Posted on May 10th, 2009 Matt Parkinson 1 comment

    Since Vista and Windows Server 2008 have been released there is no longer a ‘runas’ option in the Windows context menu. Although you can still use ‘runas’ from the command prompt Mark Russinovich has written a new program called ‘ShellRunAs’ which adds the ‘runas’ feature back into the context menu. To get this feature back please download the zip file attached to this blog post and follow the steps below.

    1. Download ShellRunAs

        ShellRunAs (49.6 KiB, 2 hits)
      You need to be a registered user to download this file.

    2. Copy the ShellRunas.exe file to C:\Windows\System32.
    3. Open command prompt and type “shellrunas /reg” and press enter.
    4. Press ok to confirm the install.
    Before ShellRunAs

    Before ShellRunAs

    After ShellRunAs

    After ShellRunAs

  • NTBackup – VSS Inconsistency Error

    Posted on May 9th, 2009 Matt Parkinson No comments

    When performing a backup that made use of the volume shadow copy service I kept seeing an error stating that “an internal inconsistency was detected in trying to contact shadow copy service writers.” After a bit of troubleshooting I found that the VSS dll files were not registered properly anymore and so I had to re-register them and reset the service. In Symantec Backup Exec the error will also show stating that the vsapi.dll is missing or corrupt. To fix this error I had to make a batch file with the following commands to re-register the dll files and restart the services. If you want to you can also type these commands straight into command prompt but I thought the batch file would be a quicker and easier method.

    • cd /d %windir%\system32
    • Net stop vss
    • Net stop swprv
    • regsvr32 ole32.dll
    • regsvr32 oleaut32.dll
    • regsvr32 vss_ps.dll
    • vssvc /register
    • regsvr32 /i swprv.dll
    • regsvr32 /i eventcls.dll
    • regsvr32 es.dll
    • regsvr32 stdprov.dll
    • regsvr32 vssui.dll
    • regsvr32 msxml.dll
    • regsvr32 msxml3.dll
    • regsvr32 msxml4.dll