log shipping question

Hi,
Log shipping from sql 2k to sql2005. How do I do it?
I have sql2005 reporting server need to be synched with sql2000 prod db for
reporting.
How do I make the dbs synched?
Thanks,
You cannot use built-in log shipping across SQL 2000 and SQL 2005 (both EM
and SSMS should error out). You should get a message stating the restore
failing abruptly and suggesting you to upgrade.
However, you can write your own scripts to backup, copy and restore across
different versions. Then you'll have to create your own tables to track the
files that are copied and use the entries in those tables to keep the
process in sync. Search google for sample scripts on custom log shipping--
you should be able to come up with your own wih minor changes.
Anith
|||Thanks for the reply, I did use my own log shipping. I still get the error;
Msg 3180, Level 16, State 1, Line 1
This backup cannot be restored using WITH STANDBY because a database upgrade
is needed. Reissue the RESTORE without WITH STANDBY.
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:udOam56fIHA.2268@.TK2MSFTNGP02.phx.gbl...
> You cannot use built-in log shipping across SQL 2000 and SQL 2005 (both EM
> and SSMS should error out). You should get a message stating the restore
> failing abruptly and suggesting you to upgrade.
> However, you can write your own scripts to backup, copy and restore across
> different versions. Then you'll have to create your own tables to track
> the files that are copied and use the entries in those tables to keep the
> process in sync. Search google for sample scripts on custom log shipping--
> you should be able to come up with your own wih minor changes.
> --
> Anith
>
|||This is one problem with the destination database in the 90 compatibility
level. Here is a response from Kevin Farlee, a SQL Mgr at MS:
"Unfortunately, although you can maintain log shipping from SQL 2000 to a
SQL 2005 instance as long as the target database is never recovered and
converted to 90 format, you cannot have the target database in standby mode.
Putting a database in standby mode implies that you are recovering the
database and writing the uncommitted changes out to the standby file. The
last stage of recovery when a 80-format database is on a SQL 2005 instance
is to upgrade the format to 90. It just doesn't logically make sense to
have a 90-format database with a standby file of 80-format changes.
As soon as the database recovers, it will be in 90 (SQL 2005) format. A
database in 90 format cannot have 80 format logs applied to it because as
Paul points out, the physical format is different."
Anith
|||Ok. It can't do it.
Is there any ideas or suggestions on how i get the report data
source(databases) and create repports in sql2005 reporting server and data
source are sql 2k?
Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:F7D3473D-16AB-4C05-9DFA-1117A2C0E667@.microsoft.com...
> ... so in other words, separate your HA requirements (fail over) from your
> scaling requirements (reports); it is not uncommon that they require
> separate techniques.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Anith Sen" <anith@.bizdatasolutions.com> wrote in message
> news:uQajj97fIHA.4760@.TK2MSFTNGP06.phx.gbl...
>