database getting offline

Discussion in 'Databases' started by ganeshnilgris, Dec 4, 2009.

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

    ganeshnilgris

    i want to get the backup of the live database in discountasp.com and need to work offline as i need to make some update. but the problem is i dont know how to get the database offline.


    any ideas..
     
    ganeshnilgris, Dec 4, 2009
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    if you want backup the database, simply use the database backup feature in the control panel.

    You do not want to take the database offline because you will not have permission to bring it online. Putting it into single user mode may be a better option.
     
    Bruce, Dec 4, 2009
    #2
  3. ganeshnilgris

    ganeshnilgris

    I used the back up feature and got the db created but i am not sure how to download the db form the place where it is stored as i dont know the place where the back up is created.
     
    ganeshnilgris, Dec 7, 2009
    #3
  4. Jose

    Jose

    The database is stored within your hosting account, in a folder called "_database". This can be accessed by connecting via FTP, and is not accessible through the web.
     
    Jose, Dec 7, 2009
    #4
  5. ganeshnilgris

    ganeshnilgris

    I thought like that only and i used FTP to connect the server and copied the db inside the database to my local folder. But my problem is when i open the db which is in the zip file it is not format which is recognised by sql Express.

    can u let me know if the above step is correct
     
    ganeshnilgris, Dec 8, 2009
    #5
  6. Jose

    Jose

    You should be able to by executing a restore command:

    RESTORE DATABASE YOUR_DB_NAME
    FROM DISK = 'path_to_the_database_bak_file'
     
    Jose, Dec 8, 2009
    #6
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