Friday, April 1, 2011

Run Windows Session without UAC

The ability to run a one time session without UAC enabled might have its uses leaving UAC enabled. The process includes closing explorer.exe from task manager. Right click on taskbar and goto task manager or press esc + shift + ctrl. Make sure to close your explorer.exe running under your username.

image

After closing explorer.exe goto file new task. Browse to “c:\windows” and right click explorer.exe and run as administrator

image

DPM doesn’t display SQL Server to protect

After finding a few others that had this issue it seemed to be that “SQLServerWriter” is not registered so DPM cannot use database level snapshots and only use volume snapshots. I had this issue with DPM 2010 and SQL Server 2008 R2. From reading the other issues it seems to be limitation by the SQL Server VSS Writer and spaces in the database name. So that would affect any version of DPM and any version of SQL that includes SQL VSS writer that continued to function this way.

Batch Script to determine is the correct services are running.

sc query VSS

sc query SQLWRITER

sc query DPMRA

VSS Command to verify SQLSERVERWRITER has registered. This command requires Administrator Elevation. In your results should include writer name: 'SqlServerWriter' .

vssadmin list writers

SQL Script to Detect which database has a space at the end of the name.

select name from sys.databases WHERE right(name,1) = ' '

Below is a script includes all checks if your SQL Server has powershell enabled.

References:

DPM 2007 / SQL 2005

http://systemcentercentral.com/BlogDetails/tabid/143/IndexID/41516/Default.aspx

DPM 2010 / SQL 2005

http://social.technet.microsoft.com/Forums/en-US/dpmsqlbackup/thread/432b4e38-6c7c-4fe0-abe5-769275784fcf#e5ae80fa-14d3-4ccc-8713-d95187864acc