ASP shop data backup MSSQL database using desktop SQL manager

[tommydog]

hi i'm trying to make a backup of my database. the data base feed my shop cart and is located on rented webspace. the cart is ASP and i'm sure the database is MSSQL. I have a freeware desktop sql manager and i'm not sure how to enter the server information ! I have another webspace with MYSQL and PHP admin that i intend to use as the backup location.

my ASP data connection script is as folows:

if strServerName = "blackorchidinteriors.kdomain.local" or strServerName = "blackorchidinteriors-shop.kdomain.local" then
    global_strServer = "kpdc-1.kdomain.local"
else
    global_strServer = "90538-APP1"
end if
 

(user and pass not shown )

global_strServe r is then used to build the connection:

global_strConnectionString = "Provider=SQLOLEDB;Server=" & global_strServer & ";database=**********;uid=*********;pwd=**********"
 

90538-APP1 seems a funny IP address !

why does this connection script have two server locations and how do i expand these addresses for remote (desktop SQL manager) access ?

am i going about this in the best way ?
should i be uploading a ASP file to do this job ?