Results 1 to 2 of 2

Thread: error in transaction backup

  1. 06-24-2003, 02:01 AM #1
    vinodk_patel
    vinodk_patel is offline Registered User
    Join Date
    Jun 2003
    Posts
    14

    error in transaction backup

    I am sometime getting error like this

    Destination: [\\yhlbackup\dbbackup\his_db\his_db_tlog_2003062311 00.TRN]
    [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4213: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot allow BACKUP LOG because file 'his_db_Data' has been subjected to nonlogged updates and cannot be rolled forward. Perform a full database, or differential database, backup.
    [Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally.

    For your more information
    I have checked out that nonlogged updates not occurred in database.
    And I implemented transactional replication.
    This database has two publications and two pull subscriptions also
    For further clarification please don’t hesitate …

    Anybody can suggest me ..
    Thanks in advance for your time.

    Vinod
    Reply With Quote Reply With Quote
  2. 07-10-2003, 02:05 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    See the database option (recovery model) on the database. something might have changed the option to "Simple mode"
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules