Technology tips: November 2013

Tuesday, November 19, 2013

If you are using Facebook text messenger on IOs so you running out of luck because Facebook is testing its new feature on Facebook text messenger so you could reach your friends faster than ever before.
If you want to experience new text messenger feature so you can try it with android phone –and you also be able to use it in October, 2013 with ios.
As you are so familiar with watsapp and when you send any message to you friend it goes directly to your friend’s inbox and get notified when they are online so they get instant notification, idea goes same here using Facebook messenger you can connect with your friends via phone number as well as with your email address.
Another feature in this messenger is its icon which is totally changed with a zigzag arrow in blue color.
And that intimates anyone who is using messenger application and someone is using this messenger from desktop or mobile so the status displays the same icon and changes it accordingly.
You can chat with your friend by adding the phone number of the friend for the first time and change its image as background while chatting with friends.

If you update your existing messenger so instantly you will be able to use these features, and your status on Facebook instantly be converted into mobile or web in green color with your name when you login Facebook.

Sunday, November 3, 2013

If you come across with a situation where you take backup and restore on hard drive that is easily done using SSMS but if it comes to network drive then it might give you tough time all the way.
Backup and restore database is easy activity using sql server management studio you can do it using single click on UI on SSMS or you can create scripts too to create back and restore it on hard drive .
In order to take sql server back up on network drive you can create a mapped drive if you want to create backup on network or restore it on network. But problem comes when you do not have permission to write on a network drive.
You will see error messages all the time while taking sql server backup on network share – reason is your sql server agent which is running under any name account does not have access on network share so either you configure another service account that has permission on network drive or path or you change service account name from services and tap sql server service and tap service account there define new account.
 
Key sequence:

Run  (command)>> Services.msc>>SQL Server Service>> Properties>> Log on>>Account Name

In this account name section you define any account that has access on network where you want to take backup or restore backup.
 By only defining authorized account name you can take backup on network share otherwise you probably end up with the smoke.
So one liner is – your sql server service account needs permission on specified network share in order to to take back up on network drive so define it.


\\NETWORKSHARE\BACKUPFILE
You need sql server service account full permission to access this resource if your service account does not have permission on this resource then you will fail to take back up.