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|||... 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...
> 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...
>> 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
>|||Why not just connect your 20905 reporting services report to your 2000 database? If that is not
possible for some reason, then I'd investigate replication from 2000 to 2005.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Mecn" <mecn@.yahoo.com> wrote in message news:OA5JM38fIHA.2448@.TK2MSFTNGP03.phx.gbl...
> 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...
>> 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
>>
>sql