Re: Log Shipping

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 18:58:28 +0200

You can restore backup from 7.0 on 2000 but not the other way around. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DBA" <DBA@discussions.microsoft.com> wrote in message
news:ABA94F10-B09E-4050-99DC-AFE7C2ACD2DA@microsoft.com...
> We have a SQL 2K server, and a SQL 7.0 server. Is it possible to log ship between different
version of SQL Server. They are both enterprise edition editions. What I want to do is ship the log
from 2K to 7.0. Is this possible?

Relevant Pages

  • Re: Rename a SQL Server 2000 virtual server (Workaround)
    ... You can manually log ship your database to the new system. ... you have a way to change your client connections fairly rapidly and you ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: MSCS SQL2000 Cluster 64 and 32 bit servers?
    ... you can log ship between editions/platforms. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: sql transactions per second
    ... good sense of app server and web server hit counts and capacity needs, ... SQL Server to the max, and what their SQL transaction per second count is. ... before all other hardware constrains growth). ... Be prepared to hire a really good DBA who knows how ...
    (microsoft.public.sqlserver.server)
  • Re: Among available RDBMS. When to use ...
    ... "When these new options are not set, SQL Server 2005 default database ... Given that Oracle's multiversioning has long outperformed SQL Server, ... is it possible to keep DBA? ... I would think an ISV needs a DBA more, ...
    (comp.databases)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... now the SQL injection attacks and/or crash the service attacks need ... to be address separately (no real DBA options here). ... The proper way to secure this though isn't in SQL Server per se. ... Microsoft's putting a lot of effort into security. ...
    (microsoft.public.sqlserver.security)