May 21, 2008 at 1:35 am
Hello Everyone
I am quite a newbie when it comes to SQL Server as most the time I rely on the DBA at the customer site to perform most of my DBA requirements, but for some reason, I am not at a customer who seems to have very limited DBA skills so I am trying to figure out somethings on my own.
I work with an application called FileNet, which is part of the IBM Software stack since IBM bought the product in 2006.
What I have done on VMWare is the following:
Have a Windows 2003 SP1 server (DEMODC) running SQL Server 2005 SP2 instance running, with 3 databases (GCD, BPF, VWdb) and of course there are the system databases. All the data files are located on C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
We are now planning on moving the databases onto a MS SQL Cluster, so what I've done is build another VMWare image (SQLMOVEDB) with SQL 2005 SP2 and I've created a drive called E:\SAN where the databases should now reside. On this new server, the master, model, msdb and tempdb already reside on the E:\SAN because that's how I've built it.
Now I've been doing reading on moving all the databases (system and 3 custom ones) to this new server, but for the life of me can't figure it out. There are a lot of articles on moving the data files from say c:\ to d:\ on the same server, but can't find anything to move between servers with different host names.
I've read this article about moving the users:
http://support.microsoft.com/kb/918992/
I am just not sure which order to do things.
I am hoping someone can point me in the right direction.
Regards
Robert Brauer
Consultant
May 21, 2008 at 4:08 am
Hope these link might help you
http://vyaskn.tripod.com/moving_sql_server.htm
http://vyaskn.tripod.com/sqlserverres.htm
Thanks!
May 21, 2008 at 4:26 am
Hey there
Thanks, for the response, I'll take a look at those and get back to you.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply