Re: problem creating warm standby on 6.5

Tech-Archive recommends: Fix windows errors by optimizing your registry

anonymous_at_discussions.microsoft.com
Date: 03/05/04 

Date: Fri, 5 Mar 2004 06:09:38 -0800

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: problem creating warm standby on 6.5
    ... I recommend that you use ISQLw and execute DUMP and LOAD ... Or you could run SQLTrace and catch the SQL commands issued by Enterprise ... >>Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • 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)
  • rdump problem
    ... I am trying to rdump from server 2 to server1 and am getting ... rcmd: socket: Permission denied ... dump: Date of last level dump: the start of the epoch ...
    (Tru64-UNIX-Managers)
  • Re: SQL Server 2005 hang up
    ... Tibor Karaszi, SQL Server MVP ... External dump process returned no errors. ... System Idle 99%. ...
    (microsoft.public.sqlserver.server)
  • Re: MMC.exe stops responding for up to 5 minutes during AD GPO browse / edit
    ... > -The oldest file in the same folder on the test VPC server is 9/25/1999 ... >>> kernel dump it should show up. ... >>>> it may be our self and that it may be a filter driver in the kernel. ...
    (microsoft.public.windows.server.active_directory)