Hi Gang,
i'm desperately trying to run through a successful backup and restore of my dotnetnuke site. i'm hosting with pipeten.co.uk if thats relevant.
i've bought both evotiva and xpidea and neither of them work, they just 'page cannot be displayed' or come up with permission errors even though the rest of dotnetnuke modules work fine with the write/read permissions on the server. i've tried it million times varying everything i can think of.
so i'm hoping someone can offer me a solution. i have to be able to backup and restore reliably.
i've tried DTS (or SSIS as i think its known now). i've made sure my local database is the same name as the remote database, same logins too. i click on my remote database, All Tasks, Extract Data. run through the wizard selecting all tables and views (i've tried just the tables, not the views also). it extracts it to my laptop's database no problem, but can i send the data tables back? no. i think one time i managed it, but i'd lost track on the state of the local database after a frustrating number of tests, and when i tried accessing the dotnetnuke site through IE - Internal Server error. fantastic.
The error i'm receiving when i'm sending the data tables back has ranged from a number of non-descript errors to more recently the mumblings of something similar to "This would violate a PK_ in data table". it's like AAARRRHH. why hasn't dotnetnuke provided a solution?
i would love to find an ISP that can offer me all the things i need for hosting domains, as well as native backup support for SQL server. but i can't find one.
what does everyone else do? there must be a fail-safe process
please help a young and struggling developer have peace of mind!!