Export a Selection List From BackupExec

For documentation purposes, it is sometimes necessary to be able to extract the selection list to a file. There are 2 ways to do this:

1. The first way is to schedule a new job with the same list. On completion of the job the selection list will be displayed. From this you can copy and paste into the document.
2. The second way is to query the Backup Exec SQL database. Execute the following SQL query to return all items in all selection list.
   SELECT [ScriptName],[ScriptDescription],[DeviceSelectionName],[PathName],[FileName] FROM [BEDB].[dbo].[vwScriptPropertiesBackup]

This query can be trimmed down using the appropriate where clause.

Exchange 2007 OWA "Insufficient Access Rights"

Occassionally, after transferring a mailbox from Exchange 2003 to Exchange 2007 OWA will not function for that mailbox. The user will receive a message "The user has insufficient access rights." To resolve this perform the following:

1. Launch Active Directory Users and Computers
2. From the View menu, select Advanced.
3. Locate the user in AD, right click, properties.
4. Navigate to the security tab.
4. Click "Advanced"
5. Click "Allow inheritable permissions from the parent to propagate to this object and all child objects.
6. Click Apply
7. Click OK and OK again.

Alter SQL Server Internal Name

SQL server maintains the local server name with the master database. The current server name can be identified by running the query:

USE master;
GO
Select * from sysservers;
GO

The srvname in the output reflects what SQL thinks the server name is. When altering a server's NetBIOS name that is running SQL, the srvname field needs to be updated. To achieve this execute the following query:

EXEC sp_dropserver 'oldname';
GO
EXEC sp_addserver 'newname', 'LOCAL';
GO

Where oldname is the server's original NetBIOS name, newname is the new NetBIOS name and LOCAL specifies that the server is a local (not remote) server.