Prev: Logfile per Trigger
Next: Official document about restoring SQL Server 2000 logs to SQL
From: Vincent D. on 22 Mar 2010 10:43
Hello,

I am trying to get a document, a technote or something, telling officially
that the transactional logs of a SQL Server 2000 SP3 can be restored to a SQL
Server 2005 SP3 database.

Did you see anything like that ?

Thanks in advance,
Regards,

Vincent
From: Uri Dimant on 22 Mar 2010 10:50
Hi
You can restore database backed up on SQL Server 2000 and restore on SQL
Server 2005/2008

Are you trying to log ship between SQL2K and SQL2005?


"Vincent D." <VincentD(a)discussions.microsoft.com> wrote in message
news:197AF810-0295-442C-AB8F-794957C6869D(a)microsoft.com...
> Hello,
>
> I am trying to get a document, a technote or something, telling officially
> that the transactional logs of a SQL Server 2000 SP3 can be restored to a
> SQL
> Server 2005 SP3 database.
>
> Did you see anything like that ?
>
> Thanks in advance,
> Regards,
>
> Vincent


From: Tibor Karaszi on 22 Mar 2010 11:49
No can do (log backup, that is). Only database backup can be restore from
lower to higher version.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"Vincent D." <VincentD(a)discussions.microsoft.com> wrote in message
news:197AF810-0295-442C-AB8F-794957C6869D(a)microsoft.com...
> Hello,
>
> I am trying to get a document, a technote or something, telling officially
> that the transactional logs of a SQL Server 2000 SP3 can be restored to a
> SQL
> Server 2005 SP3 database.
>
> Did you see anything like that ?
>
> Thanks in advance,
> Regards,
>
> Vincent

 | 
Pages: 1
Prev: Logfile per Trigger
Next: Official document about restoring SQL Server 2000 logs to SQL