Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Backup/Restore Expand / Collapse
Author
Message
Posted Thursday, February 20, 2014 8:28 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #1543794
Posted Thursday, February 20, 2014 10:52 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, December 24, 2014 7:00 AM
Points: 828, Visits: 1,440
There is great learning every day through QOD. Thanks for the question
Post #1543825
Posted Thursday, February 20, 2014 11:25 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 10:56 PM
Points: 1,981, Visits: 589
Informative QOD.

-----------------
Gobikannan
Post #1543830
Posted Friday, February 21, 2014 12:08 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 12:56 AM
Points: 275, Visits: 22
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号
Post #1543844
Posted Friday, February 21, 2014 2:27 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:39 AM
Points: 4,164, Visits: 5,563
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


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1543870
Posted Friday, February 21, 2014 3:05 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #1543884
Posted Friday, February 21, 2014 3:14 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Sunday, December 7, 2014 11:43 PM
Points: 592, Visits: 126
I found this article with the answer to the question.

[url=http://www.mssqltips.com/sqlservertip/1921/best-practices-for-working-with-read-only-databases-in-sql-server/][/url]
Post #1543888
Posted Friday, February 21, 2014 5:38 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 4:06 AM
Points: 3,130, Visits: 3,252
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,
SQL Server developer at Seavus
www.seavus.com
Post #1543937
Posted Friday, February 21, 2014 5:50 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 11:36 AM
Points: 4,625, Visits: 4,085
That was a good question. Thanks.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1543940
Posted Friday, February 21, 2014 6:45 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, December 8, 2014 5:37 AM
Points: 751, Visits: 967
Ed Wagner (2/21/2014)
That was a good question. Thanks.
Post #1543947
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse