SQL2005 Remote Connection to Discountasp ??

Discussion in 'Databases' started by cmoon99, Oct 10, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. cmoon99

    cmoon99

    I have a nightly process that logs into discountasp and downloads a .mdb right to our server. I am switching to SQL2005. Would I be able to download an SQL 2005 database the same way (do I need the .mdf, .bak, or both?). Better yet, is there a way to connect remotely to discountasp.net and see the database through my SQLServer ManagementStudio?Any suggestions/scriptexamples would be appreciated. Thanks!
     
    cmoon99, Oct 10, 2006
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    You should be able to connect to our SQLservers using any SQL client including Management Studio.


    It is not possible for you to schedule our SQL server to backup your database and send it to your local computer.


    If you want to move the data and you have SQL 2k5 server installed locally, you can consider creating a DTS package that migrate all the data and schedule it on your own SQL server.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Oct 10, 2006
    #2
  3. neilfire

    neilfire

    Is it possible to backup my database to my local drive? I dont seem to be able to at the moment
     
    neilfire, Oct 21, 2006
    #3
  4. Aristotle

    Aristotle

    It is not possible to perform a SQL backup directly to your local drive. You can use the backup tool in your discountasp control panel, which saves the backup on your site where you can then download from.

    Aristotle

    DiscountASP.NET
    www.DiscountASP.NET
     
    Aristotle, Oct 21, 2006
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page