472,354 Members | 1,437 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,354 software developers and data experts.

ASP shop data backup MSSQL database using desktop SQL manager

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:

Expand|Select|Wrap|Line Numbers
  1. if strServerName = "blackorchidinteriors.kdomain.local" or strServerName = "blackorchidinteriors-shop.kdomain.local" then
  2.     global_strServer = "kpdc-1.kdomain.local"
  3. else
  4.     global_strServer = "90538-APP1"
  5. end if
(user and pass not shown )

global_strServer is then used to build the connection:

Expand|Select|Wrap|Line Numbers
  1. 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 ?
Oct 11 '06 #1
0 1694

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Pablo | last post by:
C:\Program Files\Microsoft SQL Server\MSSQL\Data\" contains .mdb and ..ldb files that are huge, some reach 21GB! while backup files don't exceed 8MB. I guess it's a kind of transaction log, but...
by: John Morgan | last post by:
I have an online SQL Server database provided by an ISP. I do not have permission to create a backup device and I understand this is normal practice. I am not using Enterprise Manager to...
by: RLN | last post by:
hi group My database name : developer day 1. Taken full backup day 2. taken differential backup
by: Mark D Powell | last post by:
Recently I created a new db in production and restored it from test. I have a nightly backup job that backs up all user databases. The backup for this new db is failing. The message in the...
by: Eric Herber | last post by:
I've a question regarding db2 (V8.1) and database backups going to a storage manager like TSM for example. As I can see in the storage manager if I backup the complete database over the TSM API...
by: Ed | last post by:
I have a MS SQL database process that is run from ASP.NET. I would like to be able to backup the SQL database using either a full database or transaction log backup immediately before the backup...
by: Najm | last post by:
Hi All, I am facing this issue very frist time. I add a logical device as following: USE master GO EXEC sp_addumpdevice 'disk', 'AdvWorksData',
by: Olegus | last post by:
Hello, in order to perform backup/restore MSSQL database using SMO, one needs to reference several namespaces in a backup class : using Microsoft.SqlServer.Management.Common; using...
by: Bootstrap Bill | last post by:
I'm looking for a PHP program to backup and restore a mysql database. I'm using Godaddy to host a forum. Their mysql control panel will only restore a database of two megabytes or less. My...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.