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


 

Domain Account Keeps locking out

One domain user's account keeps locking out. I have checked the credential manager to remove all without luck till I found this article ...