Print Page | Close Window

Moving SQL Database

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=28912
Printed Date: 01 April 2026 at 3:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Moving SQL Database
Posted By: WayneJ
Subject: Moving SQL Database
Date Posted: 19 October 2010 at 4:16pm
Hi,
 
I'm hoping someone can help me - I've searched for some documentation on this, but cannot find any.
 
We are running version 9.61 with SQL server for the database.  I need to move the database to a different server - part of a server replacement program - I have the server installed, have backed up and restored the database to the new server, but cannot find where the settings are to point the forum to the new database location.
 
Can anyone point me to where these settings are?
 
 
Thanks

Wayne
 



Replies:
Posted By: 123Simples
Date Posted: 19 October 2010 at 5:54pm
It depends on where your forum files are being stored. Normally they would be on the same server as your forum I would have assumed. The database connection file will give you the current settings that you have. The file is in the forum/database folder and is called database_settings.asp

As an example
'**********************************************************
'***        Microsoft SQL Server and MySQL Server        ****
'**********************************************************

'Enter the details of your Microsoft SQL Server or MySQL Server and database below
'*********************************************************************************

strSQLServerName = "mywebshost.com" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
strSQLDBUserName = "myusername" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "myserverpassword" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "thenameofmydatabase"



-------------
http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design


Posted By: WayneJ
Date Posted: 21 October 2010 at 10:52am
Thats great.  Thanks, MrTWS.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net