Web Wiz Support and Community Forums : Move to a new server. https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 18:20:59 +0000 Tue, 08 May 2007 16:44:27 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=23268 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Move to a new server. : Just as a quick not if you are...]]> https://forums.webwiz.net/move-to-a-new-server_topic23268_post122583.html#122583 Author: WebWiz-Bruce
Subject: 23268
Posted: 08 May 2007 at 4:44pm

Just as a quick not if you are moving from SQL Server 2000 to SQL Server 2005 the only way to do this is to detach then re-attach the database.]]> Tue, 08 May 2007 16:44:27 +0000 https://forums.webwiz.net/move-to-a-new-server_topic23268_post122583.html#122583 <![CDATA[Move to a new server. : when i&#039;ve gone from one server...]]> https://forums.webwiz.net/move-to-a-new-server_topic23268_post122577.html#122577 Author: ctscott
Subject: 23268
Posted: 08 May 2007 at 3:02pm

when i've gone from one server to another with databases other that Web Wiz I:
1.  backed up the DB on the old server
2.  copied the backup file to the new server
3.  went into Enterprise Manager
4.  went to the DB I wanted to restore to
5.  right clicked, selected "All Tasks"
6.  selected "Restore database"
7.  selected restore from "Device"
8.  added my file to the the Device list
9.  restored my database.
10.  adjusted database Users as needed.
 
works for me.  may not be the best way tho.
]]> Tue, 08 May 2007 15:02:40 +0000 https://forums.webwiz.net/move-to-a-new-server_topic23268_post122577.html#122577 <![CDATA[Move to a new server. : There are a number of ways to...]]> https://forums.webwiz.net/move-to-a-new-server_topic23268_post122573.html#122573 Author: WebWiz-Bruce
Subject: 23268
Posted: 08 May 2007 at 7:43am

There are a number of ways to do this, the simplest is to detach the database in your old server move the 2 database files to the new server and reattach them.

If this fails and the backup method you mention fails you can use the import/export tools in the SQL Management Studio, although make sure after you still have your default values as it doesn't always move these across.
]]> Tue, 08 May 2007 07:43:41 +0000 https://forums.webwiz.net/move-to-a-new-server_topic23268_post122573.html#122573 <![CDATA[Move to a new server. : Just got me a new Dell Poweredge...]]> https://forums.webwiz.net/move-to-a-new-server_topic23268_post122567.html#122567 Author: neomatrix2006
Subject: 23268
Posted: 08 May 2007 at 5:58am

Just got me a new Dell Poweredge rack server, I could use some advice on moving my forum from my old server to my new one. I am running wwf 8.05. I am running sql server 2005 and windows server 2003 on both machines. I tried to just backup the database on the old server to be restored on the new one, but sql manager will not let me restore the backup to the new server, I dont think that I am doing it right, so anyone who could help me, please do.

Edited by neomatrix2006 - 08 May 2007 at 5:59am]]> Tue, 08 May 2007 05:58:42 +0000 https://forums.webwiz.net/move-to-a-new-server_topic23268_post122567.html#122567