Wednesday, August 26, 2009

Troubleshooting Netbackup connections

Use "bpclntcmd -pn":
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.

Thursday, August 20, 2009

Installing SQL 2005 Reporting Services

This install assumes 2 server, one for SQL and one for web/IIS part.

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

Tuesday, August 18, 2009

SQL 2005 build versions after SP2

Reference: http://support.microsoft.com/kb/937137/LN/

Unattended Execution Account

If using a local account for this, I found I had to give it the User Right "Allow log on locally". Otherwise, the account is just a normal Users group account on the Reporting Services test server. SQL 2005, SSRS, and IIS are installed on the same (virtual) server.