Re: problem creating warm standby on 6.5
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/05/04
- Next message: William Morris: "Re: Import + ActiveX (cross)"
- Previous message: Chip: "Re: What should be my reply?"
- In reply to: anonymous_at_discussions.microsoft.com: "Re: problem creating warm standby on 6.5"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: problem creating warm standby on 6.5"
- Reply: anonymous_at_discussions.microsoft.com: "Re: problem creating warm standby on 6.5"
- Messages sorted by: [ date ] [ thread ]
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? > > > > > >. > >
- Next message: William Morris: "Re: Import + ActiveX (cross)"
- Previous message: Chip: "Re: What should be my reply?"
- In reply to: anonymous_at_discussions.microsoft.com: "Re: problem creating warm standby on 6.5"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: problem creating warm standby on 6.5"
- Reply: anonymous_at_discussions.microsoft.com: "Re: problem creating warm standby on 6.5"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
