We have a very small Sharepoint Foundation 2010 farm with a library and some workflows. We want to build this originally on one server using SQL Server Express 2008 R2.
However, there is a chance this could grow into something bigger in which obviously the design would have to change, but in the meantime...we are treading carefully with a small and cheap environment.
My question stems from Microsoft's article on moving databases: (http://technet.microsoft.com/en-us/library/cc512723.aspx#Alias)
It makes sense for the most part, except for the part where we configure the SQL alias to point to the new SQL database server. Is what Microsoft saying here is that we will always have a pointer which will redirect the system to the new database server? I'm surprised that once you have turned the pointer over to the new system, you cannot go into central admin and change the database servername.