I am on Windows XP SP3 32 bit, and this command:
adb pull /sdcard/settings.db %userprofile%\desktop
does nothing. All I get with that is the ADB help output. The settings.db file that was created never gets pulled to desktop.
So I also changed it to:
adb pull /sdcard/settings.db
and the file gets successfully pulled to the sdk tools directory. I think it's because on my OS:
%userprofile% = C:\Documents and Settings\<username>
and the command adb can't handle the spaces in the variable.
Therefore I also changed this:
adb push %userprofile%\desktop\settings.db /sdcard
adb push settings.db /sdcard
Everything is fine so far, except Firefox wont let go of the stupid settings.db file in the sdk tools directory for me to delete it.
P.S. - The SDK install asked me to append %path% with the sdk/tools location as part of the installation. If you followed that step, there is no need to do change directories to there first or to worry about %userprofile% containing spaces. It'd be better to change directories over to your preferred location to store settings.db and invoke adb from there.