Database Move

Deano

unread,

May 4, 2007, 3:31:01 AM5/4/07

to

Hi There,

I'm runing LCS 2005 w/SP1 Enterprise on a dedicated server, however the back
end database is sitting on a SQL cluster. Now the cluster is being
decomissioned and I need to move the database off this cluster. Is there
anyway to easily move this database off this server and onto another SQL
server?

Are there any MS tools to do this?

Cheers

Lee Mackey (MVP)

unread,

May 4, 2007, 11:16:57 AM5/4/07

to

Depending on how the cluster is being decommissioned, what I would do is stop all LCS services. Backup your LCS database. (if the servers are being totally removed, create a new server with the same name and instance as the cluster you were using before) then restore the database. If that’s not possible, then you’ll have to change your configs to point to the new database. You can Use LCSCmd, and use the UpdatePoolBackend feature to point the pool to the new backend server.

--

-Lee Mackey

HP Services

"Deano" <De...@discussions.microsoft.com> wrote in message news:76460536-107F-4D8E...@microsoft.com:

Charlie

unread,

Jun 14, 2007, 2:32:01 PM6/14/07

to

Hi Lee,

I tried following very involved step in moving database from the
LCS_2005_SP1_Deploy_EE.doc (page 45)... and it didn't work too well...

But from what you're saying... can I just do this...

*Backup Database on BE server
*Restore Database on new BE server (new name)

*Then from the new BE server run the following command : (step 3 from the
guide)

LcsCmd.exe /forest /action:UpdatePoolBackend /poolname:”pool name of your
old pool” /poolbe:”new sql instance name for the pool – machine\instance name“

To simply update where the new BE server is... is this all thats needed?

Lee Mackey (MVP)

unread,

Jun 14, 2007, 5:36:10 PM6/14/07

to

That’s what I’ve done before and it worked correctly.

--

-Lee Mackey

HP Services

"Charlie" <Cha...@discussions.microsoft.com> wrote in message news:49B9C1A5-D8E1-44B5...@microsoft.com:

Tom

unread,

Jun 14, 2007, 6:31:03 PM6/14/07

to

Is this supported?

"Lee Mackey (MVP)" wrote:

> That's what I've done before and it worked correctly.
>
> --
>
> -Lee Mackey
>
> HP Services
>
>
>
>
>
> "Charlie" <Cha...@discussions.microsoft.com> wrote in message
> news:49B9C1A5-D8E1-44B5...@microsoft.com:
>
> > Hi Lee,
> >
> > I tried following very involved step in moving database from the
> > LCS_2005_SP1_Deploy_EE.doc (page 45)... and it didn't work too well...
> >
> > But from what you're saying... can I just do this...
> >
> > *Backup Database on BE server
> > *Restore Database on new BE server (new name)
> >
> > *Then from the new BE server run the following command : (step 3 from the
> > guide)
> >
> > LcsCmd.exe /forest /action:UpdatePoolBackend /poolname:"pool name of your

> > old pool" /poolbe:"new sql instance name for the pool - machine\instance name"

Lee Mackey (MVP)

unread,

Jun 14, 2007, 6:39:37 PM6/14/07

to

I’m not sure on the Official Support for this, but it is in the documentation. You might call PSS to get their “official” word on this.

--

-Lee Mackey

HP Services

"Tom" <T...@discussions.microsoft.com> wrote in message news:6554CBBF-3165-499F...@microsoft.com:

Tom

unread,

Jun 14, 2007, 7:03:01 PM6/14/07

to

Which docs?

Lee Mackey (MVP)

unread,

Jun 14, 2007, 9:05:33 PM6/14/07

to

LCS_2005_Deploy_EE.doc page 44. It’s in their documentation on how to run the command, so I would assume it’s supported. Don’t take that to the bank, but I’ve done this before and it worked, so not sure what else you need “supported”. Again, you might check with PSS to see if you are going to have any challenges, but I don’t see why you would.

--

-Lee Mackey

HP Services

"Tom" <T...@discussions.microsoft.com> wrote in message news:7B40C172-3745-4041...@microsoft.com: