MS SQL SERVER Import

Discussion in 'Pre-sales questions' started by Guest, Sep 4, 2011.

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

    Guest Guest

    We have a SQL Server 2008 .bak file from another provider.

    CAn we "Restore" it to a DB here?

    If not, how can we get the DB structure and data loaded the first time. DB size is about 12 MB
     
    Guest, Sep 4, 2011
    #1
  2. RayH

    RayH DiscountASP.NET Lackey DiscountASP.NET Staff

    Yes, you need to order the MS SQL 2008 database addon service first, and you can restore it with the tools offered in our Control Panel. You will need to upload the file using FTP. Please see this knowledgebase article:

    http://support.discountasp.net/KB/a188/sql-2008-management-tools.aspx

    If you run into problems, you could always try restoring the backup locally using SQL Server Management Studio, detach the database, upload the .mdf file and use the Attach function in the Control Panel to restore the database.
     
    RayH, Sep 4, 2011
    #2
  3. iconomania

    iconomania Guest

    Try to insert use master; go; before the restore. Also, before the restore, make sure you DROPPED all the connection to that database, otherwise the restore wont be successful. For more info, try opening the SQL Server Management Studio Express, and click on "Script" button on the Restore/Backup Form.
     
    iconomania, Apr 22, 2012
    #3
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