Backup/Restore

  • Comments posted to this topic are about the item Backup/Restore

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • There is great learning every day through QOD. Thanks for the question

  • Informative QOD.

    -----------------
    Gobikannan

  • thank you every day we can learn knowledge, explains very details.

    thanks,

    Ke

    thanks & best regards,
    ke liu
    86+15011472596
    qq: 421190916
    email: qqliukk@hotmail.com
    河南省周口市商水县袁老乡 第二初级中学 教师公寓3号

  • This was removed by the editor as SPAM

  • Stewart "Arturius" Campbell (2/21/2014)


    I can understand why one backup of a read-only db might be needed, but would subsequent backups be necessary or relevant, as nothing would have changed?..

    Interesting question, thanks

    Hello Stewart,

    In that case, subsequent backup is not required.

    Cheers!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • I found this article with the answer to the question.

    [/url]

  • The question is trivial.

    To ensure myself, I read this reference http://technet.microsoft.com/en-us/library/ms186388.aspx and I didn't see any correlation of the model's read_only property to the same for the restoring database. I restored a test database on an instance with model's read_only property set to True and False, and in both cases the test db restored with read_only=True (as it was taken with).

    Regards,

    Igor

    Igor Micev,My blog: www.igormicev.com

  • Ed Wagner (2/21/2014)


    That was a good question. Thanks.

  • Igor Micev (2/21/2014)


    The question is trivial.

    To ensure myself, I read this reference http://technet.microsoft.com/en-us/library/ms186388.aspx and I didn't see any correlation of the model's read_only property to the same for the restoring database. I restored a test database on an instance with model's read_only property set to True and False, and in both cases the test db restored with read_only=True (as it was taken with).

    Regards,

    Igor

    +1

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • My 2 cents on this issue, If you get an mdf, ldf of a read only database and attach it to your server it will retain the read only properties. (Same as Back up and Restoring the Database).

  • The read_only property of the model database has no effect on newly created databases, however created. Whatever the model value is, the value for database created by restore is the value in the backup being restored, for database created by ATTACH it is as specified in the files being attached, and for database created by CREATE DATABASE it is FALSE. The property in model determines only whether model can be written or not.

    Tom

  • Igor Micev (2/21/2014)


    The question is trivial.

    To ensure myself, I read this reference http://technet.microsoft.com/en-us/library/ms186388.aspx and I didn't see any correlation of the model's read_only property to the same for the restoring database. I restored a test database on an instance with model's read_only property set to True and False, and in both cases the test db restored with read_only=True (as it was taken with).

    Regards,

    Igor

    + 1 true, model database Read-only property has no effect here!

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • I got it,it was easy for me.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Viewing 15 posts - 1 through 15 (of 25 total)

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