Re: problem creating warm standby on 6.5

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 15:18:46 +0100

It is very difficult to troubleshoot these things if we're don't know what
is going on. I recommend that you use ISQLw and execute DUMP and LOAD
command instead. Then you can post these commands here.
Or you could run SQLTrace and catch the SQL commands issued by Enterprise
Manager as you navigate the dialogs there... 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
<anonymous@discussions.microsoft.com> wrote in message
news:79bf01c402bb$7eacf2e0$a401280a@phx.gbl...
> I'm using the backup/restore tool in Sql Enterprise
> Manager.
> >-----Original Message-----
> >Can you should use the DUMP and LOAD commands that you
> are using?
> >
> >-- 
> >Tibor Karaszi, SQL Server MVP
> >http://www.karaszi.com/sqlserver/default.asp
> >
> >
> >"whome" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:6fa701c40208$5d83f720$a401280a@phx.gbl...
> >> I have a 6.5 server with a production db on it. I
> created
> >> a copy of that db on another server. I can apply the
> >> backup dump from the prod server to the standby server
> >> fine, but when I go to apply the logs from the prod
> >> server, I get errors saying something like "log out of
> >> sequence. dump was created at 11:00 pm, log at 10:00 am"
> >> What's wrong?
> >
> >
> >.
> >

Relevant Pages

  • Re: Moving a PostgreSQL database from one server to another
    ... it seems those are commands ... > to be typed in at the BASH shell, not inside psql... ... A running server hooks into the db and blocks the dump. ...
    (Fedora)
  • Re: Copy SQL Server 6.5 Database
    ... then a restore on the new 6.5 server. ... You can do the dump and restore through Enterprise Manager. ... Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: problem creating warm standby on 6.5
    ... I'm using the backup/restore tool in Sql Enterprise ... >Tibor Karaszi, SQL Server MVP ... >> I have a 6.5 server with a production db on it. ... >> backup dump from the prod server to the standby server ...
    (microsoft.public.sqlserver.server)
  • RE: RPc server is unavailable since SP1
    ... After these commands run successfully, ... RPc server is unavailable since SP1 ... >> when the member server update certificate you get the error message RPC ... >> interface security settings before the installation of SP1 will be lost. ...
    (microsoft.public.windows.server.sbs)
  • Re: z/OSs basis for TCP/IP
    ... direction in the IP component of z/OS Communications Server is to get rid ... The Pascal socket interface uses the IUCV/VMCF services for a limited set ... TSO HOMETEST, LPQ, LPR, LPRM, LPRSET, TELNET, and TESTSITE commands ... - that the generically named TCPIP.DATA data set HOSTNAME ...
    (bit.listserv.ibm-main)