Moving Whole Forum to new Host
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=26614
Printed Date: 02 April 2026 at 11:45pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Moving Whole Forum to new Host
Posted By: dfrancis
Subject: Moving Whole Forum to new Host
Date Posted: 04 December 2008 at 3:02pm
|
Hi Bruce and all...
I know I haven't posted in a while though I read every day. I have a question that has been bugging me and some others I know for a while.
I have tried to backup and reinstall the forum database using MS DTS (SQL Data Transformation Service) many times and it always fails on the indexes. I'm not sure if anyone has found a work around for this and thought I would raise the question.
BUT
My main question is, has anyone found a way to move a forum database from one SQL server to another without errors? Basically, I am consolidating my hosting accounts to a dedicated environment and I would really like to move the forums, data, posts and members transparently. If there is a solution such as this, it could also be used to "mirror" the data on a local server which is an issue I have been unable to resolve.
Anyone have any ideas??? ------------- “If you want things to be different, you must be willing to do different things!” http://www.DavidFrancis.org/?wwf=signature" rel="nofollow - David Francis |
Replies:
Posted By: Putz22
Date Posted: 04 December 2008 at 3:17pm
| Have you tried the import tools for the DataBase? I have not had a problem with it... as always I know you have made a backup... try to make a backup without running any other programs.. as you make that Backup of the Data Base you should be able to you the import tool to keep all the database in tact.. |
Posted By: WebWiz-Bruce
Date Posted: 05 December 2008 at 1:29pm
|
To move the SQL Server database to a new server keeping the schema intact you can either:- 1. Make a full backup of the database (a .bak file) then restore the database on a the new server 2. Detach the database from SQL Server then move the .mdf and .ldf files to the new SQL Server where you reattach the database. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: dfrancis
Date Posted: 05 December 2008 at 3:50pm
|
perfect... thanks ------------- “If you want things to be different, you must be willing to do different things!” http://www.DavidFrancis.org/?wwf=signature" rel="nofollow - David Francis |
Posted By: billd3
Date Posted: 05 December 2008 at 8:01pm
|
OR, purchase webwiz hosting, give them the admin id and password for the current/old SQL setup, and buy Bruce a beer and they will move it. Our forum was moved over seamlessly in minutes, thanks to the crew at webwiz hosting! ------------- BillD http://theamcpages.com http://theamcforum.com |
Posted By: elaen
Date Posted: 12 February 2009 at 6:29am
|
it is the first time that i come here,yeah...... ------------- http://www.tradingcompany.com/index.php |
Posted By: Lynford
Date Posted: 13 February 2009 at 2:50pm
Same as that - Superb service. Had crappy old Access upgraded to SQL and an old version of WWF upgraded to the latest version at the same time. Great value for money & Service  |
billd3 wrote: