I've got a website on the hosting that is shared. I wish to perform a full backup of the Sql-Server 2005 database. I'm able to connect with db using server management studio however i canrrrt do full backup because I cannot achieve any filesystem (because of hosting restrictions). Can anybody help?
You need to speak to your hosting and find out the things they recommend to create full backup, meanwhile you should use Import/Export Data to transfer data to some local Database.
Edit: After searching for this problem I discovered the next article: instantly taking backup of database on hosting that is shared getting SQL Server 2005 express on my small machine ? Plz guide
You will find tools like Website 2 Backup to complete automatic and encoded website files and database backup on hosting that is shared. Backup copies could be saved in your area, on ftp or/and email. A restoration product is integrated.