Snitz Forums 2000 - Copy members from one database to another

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: Database: MS SQL Server

Copy members from one database to another

New Topic

Topic Locked

Printer Friendly

Author

Topic

guido331
Starting Member

USA
25 Posts

Posted - 15 September 2005 : 10:23:03

We had a catastrophic server crash last week and lost our SQL server and its databases. Unfortunately the backups we had were corrupt so they can't be used.

I have a fairly recent copy of the database and I can mount it successfully in SQL but I get all sorts of errors regarding the various mods I had installed when I try to browse the site.

I'd like to start over with a clean database and install all my mods again but I need to keep my users intact. I tried copying over FORUM_MEMBERS into the new database but the members list still only shows the Forum Administrator when I view the members list. Is there something else I need to copy over from the old database?

Podge
Support Moderator

Ireland
3776 Posts

Posted - 15 September 2005 : 10:41:57

Before you copy over the members tables you should run setup.asp and create all the tables first.

How did you copy over the members table? If you used DTS did you copy everything e.g. the members table AND objects ?

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.

Edited by - Podge on 15 September 2005 10:45:32

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.15 seconds.