Using the SQL Server 2005 database an my ISP

Posted on 2007-10-01
Last Modified: 2013-12-17
I assume I should:

1) create a database locally
2) detach the database
3) FTP it to my website

Then, how to I attach it to the database running at my ISP.  I do not have a Windows Desktop associated with my website, instead I intend to use a cheap website.  How do I detach the database from the website's SQL Server?

Once I have the database attached, then I need to create a connection string to it.

What information do I need from the ISP to connect to SQL Server?  I presume that once I create a valid connection string I'll be able to connect to my database.

Do I have it right?  What am I missing?

Question by:newbieweb
    LVL 15

    Accepted Solution

    It will depend on the access level you have at your host. If you don't have full access, you may be able to send them the db file and have them manually attach it for you. I suggest calling your host and asking them for the best way to accomplish your goal.

    Author Comment

    thanks.  I would certainly want to be able to do the attaching myself.  Glad I asked before I picked an ISP.

    Can you suggest one where I would have control?
    LVL 5

    Assisted Solution

    I think that your ISP must have a dashboard or an SQL Script execution interface that should allow you to execute the script to create the structures in your assigned database. I doubt they'll allow you to attach because the SQL server is most likely shared by many users. Just script your entire database and run the script to create it on the host site.
    LVL 15

    Expert Comment

    It will probably be much more expensive to have that level of control. I use GoDaddy and have no direct access to DB files, but boast a 100% data retention rate and will provide a backup DB file if you ask nicely.

    If you find a better solution, let me know!


    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now