Using the code
Step 1. Copy/type the below given SQL.
Step 2. Change @DBName to < Database Name>, @DBName_log to <Log File Name>
Step 3. Execute the SQL.
ALTER DATABASE @DBName SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(@DBName_log, 1)
ALTER DATABASE @DBName SET RECOVERY FULL WITH NO_WAIT
In SQL Server data is stored using two physical files:
- (.mdf) extension which contains the data.
- (.ldf) extension which contains log.
Log file size increases very rapidly and depend on the operation performed on the data. After a long time period this file becomes too large. When log file is too large it takes time to perform some operations like ( attach , de-attach, backup, restore … etc ).
This article explains how to configure your Windows Server 2008 R2 Active Directory Primary Domain Controller to syncronise time with an external time source.
Note: In an active directory, all member computers will sync time with the PDC, so you only need to setup an external time source on the PDC.
Open an elevated command prompt and type the following:
Note: this is for switzerland. More NTP names can be found here: http://www.pool.ntp.org/en/
w32tm /config /manualpeerlist:"0.ch.pool.ntp.org 1.ch.pool.ntp.org 2.ch.pool.ntp.org 3.ch.pool.ntp.org" /syncfromflags:manual /reliable:yes /update
net stop w32time
net start w32time
w32tm /config /update
You can run W32tm /resync on member computers to sync time with the PDC.
Configure the Windows Time service on the PDC emulator in the Forest Root Domain
How can I find all computer accounts in my Active Directory domain that have been inactive for x days using PowerShell?
This would give you all computer accounts that have no activity for the last 365 Days.
Search-ADAccount -AccountInactive -ComputersOnly -TimeSpan 365.00:00:00
This would sort it for you by lastlogondate.
Search-ADAccount -AccountInactive -ComputersOnly -TimeSpan 365.00:00:00 | Sort-Object lastlogondate | Ft name,lastlogondate -auto
This would give you disabled computer accounts.
Search-ADAccount -AccountDisabled -ComputersOnly
On a recently setup Windows Server 2008 R2 terminal server, Java was installed, and by default the JRE will enable automatic updates for all users. No daily users have administrative privileges, but all users are prompted to install updates. No users can actually install the available updates, nor can they disable the update check via the Control Panel.
I’m streaming a lot of my media directly to my Samsung TV (Allshare). lately I added music to my Music Library in Microsoft Windows 8. The Library is shared using DLNA Protocol. For some reason, the newly added media did not show up am my Samsung TV. I started playing around with the configuration of DLNA/Homegroup/Sharing and finally I realized (and that’s an assumption), that the whole sharing stuff, especially when it comes to indexing the media, is managed by Windows Media Player (WMP).
I started Windows Media Player and under Streaming I clicked on More Streaming Options
Combobox Show Devices On => choose All networks
Select the relevant Device and click on Customize.
Then uncheck “Use Default settings”
and then check “Make all my media available to this device.”
Finally my newly added media has shown up in Allshare/Samsung TV.
Querying EventLog using PowerShell.
Count the number of occurences of Kerberos Entries in System Eventlog for the last 24 hours
(Get-EventLog -LogName System -Source Kerberos -After (Get-Date).AddDays(-1)).Count
output the all Kerberos entries in System Eventlog for the last 24 hours:
Get-EventLog -LogName System -Source Kerberos -After (Get-Date).AddDays(-1)
on Instagram: http://instagr.am/p/LsAFJSzDwj/
eSMS by Dolphin Systems allows you to send and receive text messages from any e-mail program.
You must have a Swisscom mobile phone number for using eSMS.
Ready for immediate use
Before you can use eSMS, you have to register via text message; follow the relevant user manual for this. You can then use eSMS immediately.
Billing directly on your mobile phone
The billing of SMS messages is done via the mobile phone bill or prepaid credit from the mobile number given at registration. The costs per SMS (160 characters) is CHF 0.20.
Very easy to use
eSMS Manual for MS Outlook 2010
eSMS Manual for MS Outlook 2007
For users of MS Outlook 2003 and other e-mail programs:
eSMS Manual for all e-mail programs