Backup/Restore

Question

Post reply

Backup/Restore

free_mascot

One Orange Chip

Points: 27169
More actions
February 20, 2014 at 8:28 pm

#289852

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."
February 21, 2014 at 2:27 am

This was removed by the editor as SPAM

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

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

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 1

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

Gobikannan SSCrazy Points: 2735 More actions · Answer 2

Gobikannan

SSCrazy

Points: 2735

February 20, 2014 at 11:25 pm

#1690980

Informative QOD.

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

qqliukk SSChasing Mays Points: 605 More actions · Answer 3

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号

free_mascot One Orange Chip Points: 27169 More actions · Answer 4

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."

TjhomasH6610 SSCommitted Points: 1690 More actions · Answer 5

I found this article with the answer to the question.

[/url]

Igor Micev SSC-Dedicated Points: 33110 More actions · Answer 6

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 SSC Guru Points: 287026 More actions · Answer 7

That was a good question. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

PRAMANA.DBA SSCertifiable Points: 5507 More actions · Answer 8

Ed Wagner (2/21/2014)
That was a good question. Thanks.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

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

rsingh.sql SSC Eights! Points: 874 More actions · Answer 10

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).

TomThomson SSC Guru Points: 104773 More actions · Answer 11

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

Hany Helmy SSChampion Points: 13921 More actions · Answer 12

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

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 13

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