Friday, March 9, 2012

problem creating warm standby on 6.5

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?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?|||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...
created
>
>.
>|||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.
> are using?
> message
> created|||will do. thanks
>--Original Message--
>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...
server
of
am"
>
>.
>

No comments:

Post a Comment