Shrink & Truncate Log File SQL 2005

Problem

Shrink log file cannot effectife resize truncate log file in sql, use to query step this type. With decrease log size them.

Solution
This Step can used in here :
1) Get Name for name in show result

USE <database>
exec sp_helpfile

2) Execution resize increasing log data size with query :

USE <database>
GO
BACKUP LOG <database> WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE ("name log", 1)
GO
DBCC SHRINKFILE ("name data", 1)
GO
exec sp_helpfile

3) See size capacity in log file.

Port Forward / NAT Remote Desktop with Modem Linksys Problem

Problem
If anytihing to do remote computer other site in office location. Example: can access office A in Jakarta city and Office B Medan City. We used Remote desktop connection (RDP). Setting allow RDP port in linksys.

Solution
1) Open modem setting, example : 172.16.10.6
2) select single port fordwarding. Select Application and gaming --> add application : RDP, External port : 3389, internal port: 3389, protocol : tcp/udp, ip address: 172.16.10.15
3)Save settings. See Picture

4) select port triggering and application : rdp , start port : 3388,  end port: 3389, protocol : tcp and udp, ip address : 172.16.10.15

5) Save settings. See Picture

Problem share printer 0X0000000d canon mp250

Problem
if you are connnect printer from other computer ms windows xp to ms windows vista or ms windows 7. example used printer canonmp250 and problem found with detail : operation failed with error 0X0000000d (see picture)

Solution
1) Install driver in computer printer location (Computer A), ip address : 172.16.10.16 and share this printer
2) Install driver in computer get share with (Computer B) and used port LPT1
    Get printer with share :
    Start --> Run --> cmd
    net use LPT1 \\172.16.10.16\canonmp2 /persistent:yes
3) Create Batch file and save startup menu start.