Um.
Does your production SQL server have a D: drive? Do you have any access to it?
The chances are that the answer to both questions is "no" unless you are doing your own hosting: if you use a hosting service, then it is very unlikely that you will have any access by default, and even less likely that the hosting company will be willing to give you access!
have a look at this:
Backing up an SQL Database in C#[
^]
It provides a way to get a backup onto your website PC, rather than the SQL sever itself (which is a good idea when you think about it!)