Wednesday, August 26, 2009
Troubleshooting Netbackup connections
When the -pn option is run on a NetBackup client, it initiates an inquiry to NetBackup master server, and the master server returns information about the requesting client to the requesting client. The information returned is, in effect, how the master server "identifies" the client server.
Good response looks like this:
C:\Program Files\VERITAS\NetBackup\bin>bpclntcmd -pn
expecting response from server master_server_01
client_01.domain.com client_01 192.168.0.30 3815
In effect, the master server identifies the requesting client as a machine named "client_01" with an IP address of 192.168.0.30.
Problem:
C:\Program Files\VERITAS\NetBackup\bin>bpclntcmd -pn
expecting response from server master_server_01
client_01.domain.com *NULL* 192.168.0.30 3815
If the output showed *NULL* for the NetBackup client name (as shown below), the client is not configured in a policy and does not show up in the image database.
Reference: http://seer.entsupport.symantec.com/docs/286620.htm
Tuesday, August 25, 2009
Disabling and undo-ing A-SIS for Netapp R200
Solution
To increase the size of an A-SIS enabled volume beyond the maximum limit for A-SIS, the A-SIS service must be turned off and the changes undone. Undoing A-SIS will re-inflate the file system and could require more disk space than is available in the A-SIS enabled volume. There is no way to expand the volume size until the undo is completed, so the recommended course of action is to create and use a temporary volume and migrate data necessary to free enough space for the re-inflation to complete.
WARNING: Once the volume is grown beyond the maximum size supported for A-SIS, A-SIS will be disabled.
WARNING: Disabling A-SIS will require additional disk space as files will be undeduplicated.
WARNING: Using "sis undo" may require rebaselining of snapmirror or snapvault relationships.
Complete the following steps to undo A-SIS: Note: The undo must be performed from diag mode. The sis undo command can take some time (hours) based on how much data is being un-deduped and the filer type.
- Enter df -s
.
Note the space saved, this is the amount of space that will be necessary for the re-inflation. - Enter df
.
Note the available space. If it is not greater than or equal to the space saved found in the previous output, space will need to be cleared using other methods to complete the undo--for example, deleting Snapshots or migrating data. - Enter sis off
. - Enter priv set diag.
- Enter sis undo
.
Once the undo is complete, the volume will be a normal FlexVol volume that can be expanded.
Applies to:
All NearStore models
Data ONTAP 7G
A-SIS
Reference: kb35784 from Netapp.
Friday, August 21, 2009
Thursday, August 20, 2009
Installing SQL 2005 Reporting Services
1. Install IIS with ASP.NET enabled to webserver.
2. Install SQL 2005 Std Ed to SQL server, database components only.
3. Install SQL 2005 Reporting services on the webserver.
4. Create SQL Account for SSRS to use to access database (see http://msdn.microsoft.com/en-us/library/ms159133.aspx) on SQL server.
5. Run the SSRS Configuration Wizard and point databases to SQL server.
6. Add users to SSRS access permissions.
Update: installed Oracle drivers to access Oracle database reports, but needed to add permissions (Users group RX) to C:\Oracle install folder so that IIS could access DLL files.
References: http://msdn.microsoft.com/en-us/library/ms159689(SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms143736(SQL.90).aspx
Wednesday, August 19, 2009
Tuesday, August 18, 2009
SQL 2005 build versions after SP2
Unattended Execution Account
Permissions and User Rights for IIS 6.0
Friday, August 14, 2009
Hung VM or VM fails to power on with swap file errors
- Login to each ESX host (via Putty or similar app)
- Run
ps -efwww | grep vm_guest_name
on each host to determine which host has the hung VM process. - If you get something like this: (This is the process that has your file open in ESX)
root 1092 1 0 10:33 ? 00:00:00 /usr/lib/vmware/bin/vmkload_app /usr/lib/vmware/bin/vmware-vmx -ssched.group=host/user -# name=VMware ESX Server;version=3.5.0;licensename=VMware ESX Server;licenseversion=2.0 build-82663; -@ pipe=/tmp/vmhsdaemon-0/vmx6a6188c22e804baf; /vmfs/volumes/48729e6e-7cf3b2df-6ca0-001ec9b1b30a/vm_guest_name/vm_guest_name.vmx - Kill the process using: kill -9 pid
, where pid is 1092 in example above. - You should be able to power on the VM now.
ESX Logs
- Login to ESX host (via Putty or similar app)
- Review files in /var/logs
Expanding a VM-Windows partition
- Power off the VM
- Expand VMDK file to final size: One method is to use VIC, Edit settings, select Hard Disk, then change New Size.
- The other is to login to ESX host and use command line tool /usr/sbin/vmkfstools –X #G pathtofile/file.vmdk, where #G is the final disk size and file.vmdk is the vmdk of the virtual server.
- Edit settings of VM and mount the Gparted-livecd-*.iso to the VM.
- Go into Options tab and change Boot Options to for entry into BIOS setup screen and make CD-ROM boot before the hard disk.
- OK to close VM Properties.
- Power on VM
- Once within GParted tool, use the defaults until into the GUI
- Click on current partition
- Select Resize
- Drag arrow to expand partition
- Click Resize
- Click Exit and Shutdown VM
- Edit settings again to remove the Gparted ISO
- Power on VM
- Login via VIC console and Windows will find new hardware.Reboot the VM to complete process.
Reference: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=994
Thursday, August 13, 2009
Netbackup Duplication jobs fail with Status Code 191
- More files are open than the memory cache manager can handle. As a result, the cache manager has exhausted the available paged pool memory.
- The backup program has tried to back up a file whose size is larger than the backup API can access on that version of the operating system. This has the same result (that is, the paged pool is exhausted).
- On the Windows 2003 server in question, 2 Registry Keys (PoolUsageMaximum, PagedPoolSize) may be created to fine-tune how the operating system manages Paged Pool Memory.
- First create PoolUsageMaximum regkey and set to DWORD value = 60. If that does not work, try value = 40. If that works, increase the value by 25% until it stops working. Go back to last working value.
- If backups are still failing, use PagedPoolSize with DWORD (hex) value = FFFFFFFF. Do not set this to any other value if you are using the /3GB switch. If you are running /3GB and /PAE together, do not set this setting without extensive testing.
References: http://seer.entsupport.symantec.com/docs/295563.htm
http://support.microsoft.com/kb/304101/en-usTuesday, August 11, 2009
Netbackup Service account user rights
To use a domain account as a service account to run the Netbackup Client Service and Netbackup Remote Manager and Monitor Service, these are the user rights required:
- Act as part of the operating system
- Create a token object
- Debug Programs???
- Logon as a service
- Replace a process level token
Reference: http://seer.entsupport.symantec.com/docs/270086.htm
Friday, August 7, 2009
Gizmodo guide to cables

Reference: http://gizmodo.com/5030810/giz-explains-an-illustrated-guide-to-every-stupid-cable-you-need
Wednesday, August 5, 2009
Performance tuning SQL 2000/2005 on Windows 2003

If the Maximize data throughput for network applications network connection option is selected, the operating system gives priority to applications that perform buffered I/O operations by caching their I/O pages in file system cache. This option may limit memory available to SQL Server for normal operation. Use "Minimize memory used".
Reference: http://technet.microsoft.com/en-us/library/ms178067(SQL.90).aspx
Proper SQL server settings

Reference: http://support.microsoft.com/kb/319942
Tuesday, August 4, 2009
ASPNET account rights
The ASPNET account is created as a local account when you install ASP.NET. The ASPNET account belongs only to the Users group on that computer. Therefore, the ASPNET account has all of the rights that are associated with the Users group and can access any resources that the Users group is granted access to. The ASPNET account inherits the following user rights from the Users group.
It also is granted:
- Log on as a service
- Log on as a batch job
- Deny log on locally
Reference: http://support.microsoft.com/kb/317012
Microsoft Office Sharepoint 2007 service accounts
Reference: http://technet.microsoft.com/en-us/library/cc263445.aspx
Monday, August 3, 2009
Uninstalling Java from Windows
- Download the Microsoft Installer Clean Up utility file and save it on your desktop.
- Double click on executable file. The installation process will start. Follow the instructions accordingly.
- Once installation process is over, go to Start -> All Programs -> Run Windows Install Clean Up utility.
- This will launch the Windows Installer Clean Up utility dialog box
Under the Installed products list, select the desired Java version that you want to remove. - Click Remove and Exit
Sunday, August 2, 2009
User rights for IIS Service Account
Access this computer from the network
- Administrators
- ASPNET
- IUSR_MachineName
- IWAM_MachineName
- Users
- Administrators
- IWAM_MachineName
- Local service
- Network service
- IIS_WPG
Allow log on locally (see Note)
- Administrators
- IUSR_MachineName
Deny logon locally
- ASPNET
Impersonate a client after authentication
- Administrators
- ASPNET
- IIS_WPG
- Service
Log on as a batch job
- ASPNET
- IIS_WPG
- IUSR_MachineName
- IWAM_MachineName
- Local service
Logon as a service
- ASPNET
- Network service
Replace a process level token
- IWAM_MachineName
- Local service
- Network service
Reference: http://support.microsoft.com/kb/812614
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/3648346f-e4f5-474b-86c7-5a86e85fa1ff.mspx?pf=true