Welcome to Justanswer! I am Dr. Altman and happy to assist you both today!
I am so very sorry to hear about your little one. My primary concern is an injury to the back back, which can be a muscle pull, pinched nerve, or even a mild disc herniation because of their anatomy.
Here is more information on herniated discs in dogs:
Ideal is to have your veterinarian evaluate your dog to definitively diagnose the problem and start on appropriate medication to control the discomfort and hopefully allow him to return to normal activities with a few weeks. Until you are able to do this please restrict activity (which often they are already doing themselves but that means no steps/ stairs and only carrying to go potty) and rotating warm and cool compresses on the back in ten minute intervals to reduce pain and increase blood flow.
You can also do light circular massage up and down the back to stimulate blood flow if this is not too painful and will allow it.
To pick your dog up please use one hand between front legs and then scooping behind back legs to avoid pressure in the middle of the back. Since he is uncomfortable standing on his back legs this should be minimized as much as possible to allow his back to rest and recover
Please let me know if you have any additional questions I can assist with. I hope you are able to get your little one comfortable soon, truly. I am online another 20 minutes to assist you both...
If you have more questions or if I can help in any other way, please do not hesitate to ask! If you would like to accept my answer, please press RATE OUR CONVERSATION at the top of your screen (I am not compensated in any other way). Bonuses are always welcome. Thanks!