Monday, August 11, 2008

how to shrink file log LDF file

1. backup log {Database} with truncate_only
2. backup database {Database} to disk='c:\Program files\MS SQL\...
3. use {Database}
dbcc shrinkfile ({LogFileName}, {SizeToShrinkTo})

[where Database is db that you want to shrink; {LogFileName} is your db log file name (not the Logfile names); {SizeToShrinkTo} can be any size you want 100

show desktop icon is not on Quick launch tool bar

Manual steps to re-create the Show Desktop icon on the Quick Launch toolbar


1.Click Start , click Run, type notepad, and then click OK.
2.In Notepad, type the following text on individual lines:
[Shell]
Command=2
IconFile=explorer.exe,3
[Taskbar]
Command=ToggleDesktop
3.On the File menu, click Save As, and then save the file to your desktop as Show Desktop.scf.

Note Notepad might automatically append a .txt extension to the file name. Remove this extension if present. The file name should be Show Desktop.scf.
The file must now be moved to the correct folder in the user profile to appear in the Quick Launch toolbar. To manually do this, use
the following methods.

a.Use the mouse to drag the Show Desktop.scf icon to the Quick Launch toolbar or another location where you want the shortcut to appear.
b.Click Move Here.