Convert your LOG file smaller

Shrink the transaction log (.ldf) file

By using this method, you can shrink the log to the desired size, ex: 1MB
+ Right-click on the database you want to shrink => Tasks => Shrink => Files

Microsoft SQL Server 2008 Shrink

+ On Shrink File box, select Log on File type drop down list and select Reorganize pages before releasing unused space then set size for the log file, ex: 1 MB as picture below:

Microsoft SQL Server 2008 Shrink Set Size Log File

+ Click OK and you’re done.
The good point of this method is you can shrink at the right time but sometime, it doesn’t work especially with Microsoft SQL Server 2005. Let’s try the second method below in case it’s does not work.

2. Completely delete the log file

The main idea of this method is it will delete the big log file and create a new log file with the minimum size.
Follow steps below:
1. Detach the database
Right-click on the database => Tasks => Detach…

Microsoft SQL Server 2008 Detach

2. Delete the big log file
This step will completely erase it from your hard drive. However, from my suggestion you should back up the log file somewhere, ex: rename it from the file location (my case is: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA)

Microsoft SQL Server 2008 Data Folder

3. Attach the database again
As we deleted the log file, so we do attach the database without the log file. Don’t worry, SQL Server will create a new log file for you which will be of the minimum size. That’s perfect!
+ Right-click Databases => Attach…

Microsoft SQL Server 2008 Attach

+ On Attach Database box, click Add…

Microsoft SQL Server 2008 Attach Add

+ Browser to the database (.mdf) file then click OK

Microsoft SQL Server 2008 Browser MDF

+ Select the log (.ldf) file then click Remove

Microsoft SQL Server 2008 Attach Remove Log

+ Finally, click OK and you’re done.

Top 15 Best Free Backup Software

Safety is what we all are looking for . So why not back up your Most precious data .Most precious data include your call letters , photos taken with your loved ones and it can be a project that you made in months and  Other stuffs like songs and movies .Now you may be thinking Yes Backing Data is an essential task to do . TechFlashed Suggest you to backup data easily with these 15 windows backup softwares and good news is that all of them are free .

Top 15 Best Free Backup Software

1. GFI Backup Free Download  :
GFI is used professionally due to its built-in VSS service. Backing up is faster and simpler because it has the capacity to volume shadow copy. You can also auto notify yourself after the backup


2. Cobian Backup Free Download :
Cobian is among the favorite Windows 7 backup softwares because of its tool selection and efficiency.Cobian Backup user interface is straightforward, and the colorful command buttons are extremely intuitive. Creating a new backup task Is extremly easy.

3.SugarSync Manager Free Download :
Back up your data automatically and get instant access anytime from your PC, Mac, or mobile device.Sugar sync is a highly rated backup application .


4. FBackup Free Download :

FBackup backs up automatically to your USB or Firewire device in either local or network location. FBackup is a free backup software for both personal and commercial use and works on Windows 7, Vista, XP, 2000 and 2011/2008/2003/2000 Server (32 and 64-bit).

5. EASEUS Todo Backup Free Download :

The freeware version of Easeus backup software has pretty much all the things you would need to take a backup of your windows system.Easy backup software to full protect your PC, like one-click system backup & recovery.And also have features of server backup as well.

6. Comodo BackupFree Download :
Comodo is perfect for beginners and advanced users of Windows.User interface is excellent will lets you know what to do next .

7. OopsBackupFree Download :

Back up your documents, images, and other files which automatically track changes to files. Oops!Backup not only backs up & recovers most recent versions of a file but also allows you to go back in time and restore older versions of your work.




8. SOS Online Backup  :

Access Your Backed Up Files on the Web--All data you have backed up can be accessed from any browser. Because your data is being backed up to the SOS cloud, you can access your data anywhere in the world by simply getting online.

9.MozBackup Free Download  :
With the help of MozBackup windows backup software you can take backup and restore mail, contacts, history, bookmarks, passwords, cache and Many more things .It is a tiny software help you to store things easily.


10.Macrium Reflect Free Download  :

Backing Up is not a difficult task when using Macrium Reflect . macrium Reflect Clone disks and create, burn, and back up disk images pretty easily . It comes with a great user friendly Interface .




11.BackUp Maker Free Download :

At this address you can get professional solution for creation of backup.BackUp Maker produces backup in PkZip standard, optionally directly onto CD or DVD and FTP servers .




12.Recuva Free Download :

Recuva is a free file recovery program that makes it extremely easy to locate files that were once thought to be lost forever.Accidentally deleted an important file? Lost something important when your computer crashed? No problem! Recuva recovers files deleted from your Windows computer, Recycle Bin, digital camera card, or MP3 player. And it's free!


13. EZBack-it-up Free Download :

It is also a good place that compares thousands of files in very few seconds and gets backups your data when you tell it to do it.Very easy to learn and use .


14.DeltaCopy Free Download  :

It is an open source, fast incremental data backup program that only copy and backup the part of file that has actually been modified. Good place for data transfer saving time and network bandwidth.  


15 .SyncBack Free Download :

Great freeware from 2BrightSparks. Discover our flagship freeware program SyncBack and more.
Yes there are indeed more backup software but According to me these 15 are the best free windows Backup softwares with which you can always have a safe copy of your data . Anyways If you want to add to the list do post it as a comment .

Read more: http://www.techflashed.com/2012/02/top-15-best-free-backup-software.html#ixzz1qsO0qMBI

How to create a folder in the name “Con” in Windows

The windows is being a wellknown os in present days. In windows when you create  a folder in the name “con” in usual method of  creating a new folder, you will obtain error message from windows. Not only for the folder name “con” but also it is impossible to create the folders in the following name.

1. PRN
2. AUX
3. CLOCK$
4. NUL
5. COM1,  COM2,  COM3,  COM4,  COM5,COM6, COM7, COM8 and COM9,
6. LPT1, LPT2, LPT3, LPT4, LPT5, LPT6, LPT7, LPT8, and  LPT9 .

The following message will be provided by windows to you.

Why you can’t create the folders in the name mentioned above?
The reason for the error message is that they are reserved keywords used by DOS. These folders are already existing folders so when you try to create these folders , windows gets confused because of repetition where to write data, either virtual con folder or real con folder. So when you try to create a folder with these names then an error message will pop up and your folder will again revert to name New Folder.
How to create a folder in the names mentioned above?
1.open CMD. For opening CMD ,simply enter term “cmd” in run and press enter.
2.  then type “MD \\.\E:\CON”. In this code E: is the drive we have selected to create the folder.You can change the place to create the folder by replacing E in the above code.

3.Now you can observe the folder with the name “con” in the drive which you have mentioned above.

Deleting the folder
1. If you delete the file created it will say that windows could not find the item.

How to delete the folder?
1. Open CMD and enter “RD \\.\D:\CON”. In this code, you have to enter the drive name where you have created the folder.
Note: In some instances, the cmd too can’t delete the folder In that instances you have to delete the folder using SafeMode.

7 Useful Hidden Features Of VLC player

Most of us are unknown of the facts about VlC PLayer which is an excellent player and is used widely . Today I got to know how important VLC player is and what can it do apart from playing videos and music files.

1. Convert Audio and Video formats: the best feature apart from playing wide range of video formats.ONe can never imagine if i say it can also convert video to different formats as well. Several different formats are supported like MP4, WMV, AVI, OGG, MP3 etc.

To access the converter:
1 Go to Media –&Convert/Save.
2. Load the file you want to convert using the Add button and click Convert.
3. Now choose the output format and output file location
You may Also Like this article : 20 + All Time Best Free Video Editing Software for Windows

2. Rip DVDs:  No one can imagine that Vlc contains a integrated basic Dvd Ripper .You might be thinking that why should i use this basic dvd ripper as you might be having high quality dvd ripper , But one thing you must note is that Vlc rips video with optimum quality .Now the question arises how can you use this fetaure. To rip aVideo follow these simple and easy steps:
1. Go to the Media menu and choose Convert&Save.
2. Click on the Disc tab. Here you can adjust the Starting Position and rip only specific titles or chapters. Enter file name making sure to end with .MPG, and start ripping. Click Save.

3. Record videos: This is an intresting features that Vlc provides you can record video during playback. The button used to enable this feature is HIdden and you need to follow these steps. To see it,
1.click on View–&Advanced Control. The record button will now appear.
2. Clicking on the button while playing a movie or video will start recording.
3.Clicking again will stop recording.

4. Play RAR files: Wow playing compressed videos in  Rar Files ? Video will be played as a normal video and you can also use the seek bar as well. Sometimes the .Rar file is breaked into several parts but with Vlc Its not a problem what you have to do is that just load the first part (.part001.rar )  and it will automatically take the rest of the parts and play the whole file.

5. Play in ASCII mode: To playback movies in ASCII art You got to enable ASCII mode,
1. open VLC media player and click on Tools &Preferences.
2. Open the section “Video” section and under “Output” select “Color ASCII art video output” from the drop down menu. Save it.
 Now play any video file to enjoy the ASCII art.

6. Listen to online radio: You can never imagine what's here in it ,  Vlc player also have hundreds of radio stations for you . You just need to enable it
1. through Media&Services Discovery – Shoutcast radio listings.
2.Now, open the Playlist and browse through the stations.
Enjoy your favorite radio stations.

7. Download YouTube and other online videos: Copy the url of the vidio of youtube which you want to download.
1.Now click on Media –&Open Network stream. Paste the URL and click Play. Once VLC starts streaming the video
2.click Tools –&Codec Information and at the bottom of the window you will see a Location box. Copy the URL and paste it on your browser’s address bar. The browser will now download the file which you can save it to your hard disk.
3.Alternatively, you can record the video.

Read more: http://www.techflashed.com/2011/10/usefull-hidden-features-of-vlc-player.html#ixzz1qsKjZgzR

How to Fix Boot Problem in Windows 7

We have often faced such booting problem in windows 7.To fix this problem we make partition with xp and then install windows 7.There is a simple way to fix this problem and it will save your time too.We can fix this problem by repairing the Boot loader files in windows 7. Following steps will help you to understand in detail.
Step 1
Power on the PC press F2 or Del key to enter into BIOS setting,change the first boot device to CD_ROM and press F10 to save settings.
Step 2
Now restart your system and insert the windows 7 DVD, it will ask to Press any key to boot from cd or dvd.
Step 3
Just press any key ,then the repairing process will starts.
Step 4

 System will load files and the below screen appears

Step 5
Click on “Repair Your Computer” as shown.

Step 6

Again some windows component will load and then the below screen appears

 Step 7
Click on “Command Prompt” and enter the following command to fix boot issue.

                                          bootsect /nt60 c:

Step 8
Now restart the system, it will boot correctly and windows will work fine.
Enjoy………………:)