Tuesday, January 24, 2012

To Exchange Online or Not

Planning

Education 

 

Friday, January 13, 2012

Simple backup script for SQL Express

in backup.bat

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\sqlcmd.exe" -S (local)\TOCTTARGPPC05 -i "C:\Documents and Settings\Administrator\Desktop\backup.sql"

In backup.sql

BACKUP DATABASE [ETLSPA] TO DISK = N'\\mbbk\backup_to_folder\mbppc\mbppc.bak' WITH RETAINDAYS = 5, NOFORMAT, INIT, NAME = N'ETLSPA-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

 

 

Install PPC on Citrix server where C is not the root drive

The root drive is Y on Citrix. Updating PPC from web or admin install will fail because there's no valid path for the installer.

Workaround:

  1. Map a temp C drive

  2. Run PPCWebMultiSelect.exe from Y:\program files\Common Files\PPC\PPCWebMultiSelectInstaller\

Thursday, January 5, 2012

GPO

Symptom: unable to R-click in Windows Explorer on Terminal server.
Solution:

  • User Configuration | Administrative Templates | Start Menu and Taskbar

  • User Configuration | Administrative Templates | Windows Components | Windows Explorer

  • User Configuration | Administrative Templates | Internet Explorer | Browser Menus


 

ordinal xxxx error in ACL

If you have received the following errors when running the ACL scripts, "The ordinal xxxx could not be located in the dynamic link libr...