Hi,
I need to move the databases created by CSF to a different SQL Server Instance.
Where and what will be the changes required to be done to get the system running again.
Ashish
Move CSF databases to a different SQL Server Instance
Hot Topic
- Dataset, Typed Dataset or NHibernate?
- Incoming Mail with Sharepoint 2007 and Exchange Server
- Is there some particular if I set IsVolatile to ture Value?
- Is it possible to launch programs (such as winword.exe) from a web part
- CSF IPTV WES Technical Overview
- Modify Left Navigation Bar in MOSS 2007
- How to get authenticated password of sharepoint site user to pass on NetworkCredential() method as parameters
- MOSS2007 Office integration...good, better, best document.
- Sharepoint development future? .NET 3.5 and beyond...
- Trigger different InfoPath forms in a single state workflow
SharePoint Products
- Upgrade to WSS 3.0
- Message visualizer
- What object is responsilbe for an action? A Design Question.
- Sharepoint Workflow and Workflow Foundation
- Create a 'custom' List with Pages
- CQWP - Custom List
- DataSet Performance issue
- RichImageField HTML-Encoded in Display Mode
- Permisison Issue - HelloWorld Example with remote client
- Lost SNK File
Move CSF databases to a different SQL Server Instance
ranadheer mac
I think you can use the CSF configuration files to map for the new SQL Server Instance if the CSF Database structure and data was not modified.
Regards,
Luis Arevalo
What is meant by "CSF Database structure and data was not modified"
We havent modified the schema of the databases.
But whats the "data" being referred in the above statement
Ashish
scorpionguy
Hi Ashish and VDeevi,
Thanks for your notes - all of the CSF databases can be moved using the following process:
(a) Stop message flowing to all instances the connector, ideally this will be done be stopping the up-stream service(s).
(b) Stop the application pool in IIS, or use iisreset.
(c) Use SQL Server tools to attach/detach, or backup/restore, or even log-shipping to move the database to a new SQL Server machine.
(d) Verify, using SQL Server tools, that the database is intact and functioning.
(e) Change the connection string(s) in the connector configuration files.
(f) Restart the flow of messages to the connector by starting the up-stream service(s).
Many Thanks, Ashish and VDeevi!!
-Rob.