| Author |
 Topic Search  Topic Options
|
iSec 
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 03 December 2006 at 1:36am |
also backup your original db and make a copy of it..do the conversion on a the copy and see if it works... this way you won't lose everything like I "stupid me" did once.
|
 |
jacobisrael
Newbie
Joined: 13 December 2005
Status: Offline
Points: 19
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 December 2006 at 2:31am |
|
Well, stupid me is even more stupider than "stupid you", as there seems to be no way to back up a database on Godaddy, and I have no other copy. Does that mean it's lost, forever?
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 December 2006 at 2:44am |
|
I hope not... can you talk to them to restore it? they should do backups every now and then...can you ask them to restore it for the date before you did the upgrade?
|
|
jacobisrael
Newbie
Joined: 13 December 2005
Status: Offline
Points: 19
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 December 2006 at 3:40am |
|
Well, just spoke with tech support at Godaddy, and they do have backups of the regular part of the web site, but the sql database is on a different server which they don't back up. oops. I'm worried that we've lost all this data, a year's worth of posts and membership info? Is that the case? Is there no way to fix this data base as it is?
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 December 2006 at 3:43am |
I'm afraid not. I almost cried when I lost about 50,000 posts and 1000 members last year.
If you're good with ASP you can retreive your data and apply it on a new database. Don't get rid of what you have now. Back it up... use a backup tool like Enterprise Manager and back it up on your local machine.
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 December 2006 at 3:58am |
|
I'd try the app against the db first. In a 7.x version, I ran a db conversion twice but the db was ok... nothing deleted, just a bunch of error messages saying it couldn't create stuff - because it was already created.
Try running 8.04 wwf against the 8.04 db. nothing to lose !
Edited by dpyers - 03 December 2006 at 3:58am
|
Lead me not into temptation... I know the short cut, follow me.
|
|
jacobisrael
Newbie
Joined: 13 December 2005
Status: Offline
Points: 19
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 December 2006 at 5:31am |
Thanks for all the great advice, especially this time of night. Wish I'd asked for it before the database was blown. Am installing Enterprise Manager right now--Godaddy confirmed that you can't back up the database on Godaddy, and they don't back up the server with the databases on it. So hopefully, after what remains of the database is backed up, the 250,000 messages and 3,000 member data can somehow be restored.
It's encouraging, dpyers, that you were able to save some of it. How much and what kind of expertise is required to fix it?
Edited by jacobisrael - 03 December 2006 at 6:13am
|
|
jacobisrael
Newbie
Joined: 13 December 2005
Status: Offline
Points: 19
|
Post Options
Thanks(0)
Quote Reply
Posted: 03 December 2006 at 5:40am |
Just ran mssql_server_setup.asp again and this is what it produced. And of course it still doesn't find the members or messages:
Error Creating the Table tblCategory
There is already an object named 'tblCategory' in the database.
Error Creating the Table tblForum
There is already an object named 'tblForum' in the database.
Error Creating the Table tblTopic
There is already an object named 'tblTopic' in the database.
Error Creating the Table tblThread
There is already an object named 'tblThread' in the database.
Error Creating the Table tblAuthor
There is already an object named 'tblAuthor' in the database.
Error Creating the Table tblPMMessage
There is already an object named 'tblPMMessage' in the database.
Error Creating the Table tblBuddyList
There is already an object named 'tblBuddyList' in the database.
Error Creating the Table tblConfiguration
There is already an object named 'tblConfiguration' in the database.
Error Creating the Table tblDateTimeFormat
There is already an object named 'tblDateTimeFormat' in the database.
Error Creating the Table tblGroup
There is already an object named 'tblGroup' in the database.
Error Creating the Table tblPoll
There is already an object named 'tblPoll' in the database.
Error Creating the Table tblPollChoice
There is already an object named 'tblPollChoice' in the database.
Error Creating the Table tblPollVote
There is already an object named 'tblPollVote' in the database.
Error Creating the Table tblEmailNotify
There is already an object named 'tblEmailNotify' in the database.
Error Creating the Table tblPermissions
There is already an object named 'tblPermissions' in the database.
Error Creating the Table tblSession
There is already an object named 'tblSession' in the database.
Error Creating the Table tblGuestName
There is already an object named 'tblGuestName' in the database.
Error Creating the Table tblSmut
There is already an object named 'tblSmut' in the database.
Error Creating the Table tblBanList
There is already an object named 'tblBanList' in the database.
Error Creating one or more Indexs
There is already an index on table 'tblSession' named 'Session_ID'.
Error Creating the Relationship between the tblAuthor and tblGroup tables
There is already an object named 'tblAuthor_FK00' in the database.
Error Creating the Relationship between the tblForum and tblCategory tables
There is already an object named 'tblForum_FK00' in the database.
Error Creating the Relationship between the tblPollChoice and tblPoll tables
There is already an object named 'tblPollChoice_FK00' in the database.
Error Creating the Relationship between the tblBuddyList and tblAuthor tables
There is already an object named 'tblBuddyList_FK00' in the database.
Error Creating the Relationship between the tblEmailNotify and tblAuthor tables
There is already an object named 'tblEmailNotify_FK00' in the database.
Error Creating the Relationship between the tblPMMessage and tblAuthor tables
There is already an object named 'tblPMMessage_FK00' in the database.
Error Creating the Relationship between the tblPermissions and tblForum tables
There is already an object named 'tblPermissions_FK00' in the database.
Error Creating the Relationship between the tblTopic and tblForum tables
There is already an object named 'tblTopic_FK00' in the database.
Error Creating the Relationship between the tblGuestName and tblThread tables
There is already an object named 'tblGuestName_FK00' in the database.
Error Creating the Relationship between the tblThread, tblTopic and tblAuthor tables
There is already an object named 'tblThread_FK00' in the database.
Error entering default values in the Table tblAuthor
Cannot insert duplicate key row in object 'tblAuthor' with unique index 'User_code'.
Cannot insert duplicate key row in object 'tblAuthor' with unique index 'User_code'.
SQL Server database is set up, but with Error! |
|
|
