Hi, I am trying to do the above. I have followed the instructions on... http://support.discountasp.net/KB/a...om-within-iis7-manager.aspx?KBSearchID=251931 but when I right click the Database Manager icon on the button I do not see the 'Create Back Up' option. When I click through on the icon to the subsequent page there is the option to run the back up but it fails. Not sure if it is something to do with the App_Data folder which I cannot seem to see when using Filezilla... should I create this in the root of my folder area? Any ideas. I have installed the IIS sql server module.
...Try double-clicking the icon for the Database Manager. It should then show a list of each connection in your sites root web.config Then double-click one of the connections. After that you will have icons above the conn area for actions and your connection will be expanded at the same time like a Tree view.
If you cannot see App_Data folder when connecting to your site with ftp, then it does not exist. You need to create it from within the same ftp client.
Now OK I had another go and now I can right click and see 'Create Backup' as menu item. I clicked on it and it ran and then said backup failed. However when I look in my App_Data folder the backup is there. Any ways I got my backup so great.
Before backing up your database, you need to remove all previous backups from App_Data folder. The backup task will fail if there is a previous backup file in this folder with the same name. Therefore it looks like that the backup that you found in this folder is the backup you took earlier.
