database getting offline

[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..

[bruce]

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.

[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.

[Ramses]

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.

[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

[Ramses]

You should be able to by executing a restore command:

RESTORE DATABASE YOUR_DB_NAME
FROM DISK = 'path_to_the_database_bak_file'