Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    india
    Posts
    67

    Unanswered: How to make a db readonly to accept tran logs?

    Hi experts,
    Pls let me know , how to make normal db to readonly + accept tran logs

    Rgds
    Srinivas Varanasi.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    1) Backup the database
    2) Restore the backup with the appropriate options.

    Note that while this does exactly what you asked for, but it makes absolutely no sense. Can you describe what you want in a bit more detail, so that someone can give you a more usable answer?

    -PatP

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Srini, you need to do this on the full restore:

    RESTORE database_name
    FROM DISK = 'blah.bak'
    WITH
    MOVE 'logical data file' TO 'c:\mssql\data\blah.mdf',
    MOVE 'logical log file' TO 'c:\mssql\log\blah.ldf',
    STANDBY = 'c:\mssql\standby\blah.ldf'

    The standby creates a standby file and makes the database read-only. You can then restore your tlog backups.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

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