Currently we have both Tridion and Content Manager database running on same machine.
We have a plan of creating a new database on another machine and linking the current Tridion CM to use new database.
Now I have question that can we run CM database and Tridion in two different machines. If yes how can we configure Tridion CM to use new database.
Please let me know your suggestions on this.
Currently we are using 2011 SP1 version.