Post reply

Log shipping

  • July 17, 2010 at 8:52 pm

    #226962

    Can I do log shipping in MS SQL Server 2008 enterprise trial 180 version

  • July 17, 2010 at 9:48 pm

    #1194603

    Yes..you can do..

  • July 17, 2010 at 9:57 pm

    #1194604

    I have just install two Instances for SQL Server 2008 enterprise trial edition .let the instances be SQL1 and SQL2 ... sales database on SQL1 when I right click on the sales database and goes to its properties...it does not shows the Transaction log shipping Page ,neither its shows mirroring page...thx

  • July 17, 2010 at 10:40 pm

    #1194605

    can you post the results of below queries

    select @@version

    select serverproperty('edition')

    select serverproperty('productlevel')

    thanks

  • July 18, 2010 at 1:45 am

    #1194613

    please see the result thanks

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)

    Jul 9 2008 14:43:34

    Copyright (c) 1988-2008 Microsoft Corporation

    Enterprise Evaluation Edition on Windows NT 6.1 <X86> (Build 7600: )

    (1 row(s) affected)

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Enterprise Evaluation Edition

    (1 row(s) affected)

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    RTM

    (1 row(s) affected)

  • July 18, 2010 at 9:34 am

    #1194633

    is the database in simple recovery mode? Needs to be at least bulk-logged for log shipping.

    ---------------------------------------------------------------------

  • July 20, 2010 at 2:47 am

    #1195360

    yes it has full recovery model.....

  • July 20, 2010 at 3:17 am

    #1195371

  • July 20, 2010 at 3:44 am

    #1195379

    interesting. This is the second thread on this subject. according to MS this option should be available. Have you tried applying SP1?

    ---------------------------------------------------------------------

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply