[THIN] Re: Moving SQL Datastore - Jeff Durbin?
- From: Michael <indy019@xxxxxxxxx>
- To: thin@xxxxxxxxxxxxx
- Date: Wed, 10 Mar 2004 19:10:07 -0800 (PST)
This is pretty much along the lines of what I was
expecting. The document I found, however, noted that
you would need to create a new db owner and fiddle
with the stored procedures. Is this not necessary?
I'll give this a this weekend so I can finally get rid
of some of this old hardware. :D
Thanks again!
Michael Saul
--- "Jim Kenzig http://thethin.net";
<jimkenz@xxxxxxxxxxxxxx> wrote:
> See http://thethin.net/archive3.cfm?id=90893
>
> I've moved the Thin archives database to different
> servers several times.
> How I do it is back it up to disk using th SQL
> backup and then create an
> empty database on the new server and restore the
> backup file. It is pretty
> simple.
>
> JK
>
> -----Original Message-----
> From: thin-bounce@xxxxxxxxxxxxx
> [mailto:thin-bounce@xxxxxxxxxxxxx]On
> Behalf Of Michael
> Sent: Wednesday, March 10, 2004 8:25 PM
> To: thin@xxxxxxxxxxxxx
> Subject: [THIN] Re: Moving SQL Datastore - Jeff
> Durbin?
>
>
> After even more searching (through google, and not
> the
> thin list archive) I found Jeff Durbin's guide to
> performing a database move.
>
> Jeff, do you still have the word format of that
> document? THe archive mangled it pretty badly, and
> I
> can't tell when you use quotes or other special
> characters.
>
> Thanks again!
>
> Michael Saul
> --- Michael <indy019@xxxxxxxxx> wrote:
> > I have been asked to move the Data Store to a new
> > SQL
> > server. Is there a recommended way to do this?
> Is
> > there anything I should look out for?
> >
> > This is the plan I was thinking of taking:
> >
> > Stop all IMA services
> > Detach database from old server
> > Move database to new server and reattach
> > Run dsmaint /config to point to the new SQL server
> > Start IMA serrvice
> >
> > Will this work? Is there anything I'm missing?
> >
> > Thanks in advance.
> >
> > Micahael Saul
> >
>
>
********************************************************
> This weeks sponsor Emergent Online.
> Emergent OnLine is the leading server-based
> computing consulting integration firm in the nation.
> Emergent OnLine delivers expert
> consulting services you can depend on.
> http://www.go-eol.com
>
**********************************************************
> Useful Thin Client Computing Links are available at:
> http://thin.net/links.cfm
>
***********************************************************
> For Archives, to Unsubscribe, Subscribe or
> set Digest or Vacation mode use the below link:
> http://thin.net/citrixlist.cfm
********************************************************
This weeks sponsor Emergent Online.
Emergent OnLine is the leading server-based computing consulting integration
firm in the nation. Emergent OnLine delivers expert
consulting services you can depend on.
http://www.go-eol.com
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
Other related posts:
