Our company has an existing yaf forum running on Server 2003 SBS which as far as i can tell is running version 1.9.0 (i did not install it). It is using SQL Server 2000.

We are upgrading the IT and i need to somehow make a fresh yaf install on another server (Server 2003 - 32bit, can't see anything when i try it on 64 bit) and copy over the existing forum.

I have managed to startup an empty forum using the 1.9.0 zip file i found on the old SBS server using SQL Server 2008.

I have tried using the export wizard to copy the database across. this is initially succesful and creates a new database. however when i then try and run the default.aspx file it runs into errors saying that the sys_vaccess table exists, if i delete it then it just creates another error instead... i can supply screenshots if required

lots of the instructions in the install.txt seem to relate to upgrading a database on a single machine and not transferring it. i tried taking a backup, but of course the new machine doesn't know that a backup was ever made of any database when i try and restore....

What is the best way to try and effect this transfer? I am making it up as i am going along, i have no experience of using ISS or SQL except that which i have gleaned in the last few days. so my problems are highly likely caused by general inexperience.

I appreciate any help that you can provide me with in this matter

dc

Don't try the export wizards. Sometimes they take the Views as tables.

"It's a case of RTFM.. the only problem being we don't have a manual!"

When I post FP:Mek in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting. (Yes I stole this off Ederon 🙂 )

thanks for your prompt reply, i have a couple of questions so that i might do this.

when i backup the database in SQL SERVER 2000 (SP3a) Can i use TOOLS->BACKUP DATABASE... menu?

if i do this then i backup to a file, i guess i can make this database.bak

i then copy this .bak file to the new server, do i need to put it in a special place, i tried C:\"SQL install dir"\BACKUP which existed already...

then when i try and restore the blank database as you suggest if i use TOOLS->RESTORE DATABASE.. i cannot find the database.bak file to select and restore from...

thanks in advance

dc

thanks very much for your help

dickon