Logshipping

Question

Post reply

Logshipping

June 8, 2011 at 7:22 am

This was removed by the editor as SPAM

Viewing 15 posts - 16 through 30 (of 47 total)

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

forsqlserver SSCoach Points: 18902 More actions · Answer 1

Why what is the problem with different instance?

Can SSRS doesnt work with another db of another instance?

and have SSRS on same instance of DB???

Thanks

Rafael Krisller Right there with Babe Points: 737 More actions · Answer 2

Good question!

Just checking it you can answer correctly, because MSDN says other thing

http://msdn.microsoft.com/en-us/library/ms187103.aspx

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 3

forsqlserver (6/8/2011)
Why what is the problem with different instance?
Can SSRS doesnt work with another db of another instance?
and have SSRS on same instance of DB???

that's right! kepping reporting database in instance DB and SSRS on another instance!!!!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

chrisfradenburg SSCrazy Eights Points: 9592 More actions · Answer 4

Good question. It made me think about what log shipping does and how it works.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

rfr.ferrari (6/8/2011)
but, with relation the High Availability, forget!!! if my server catch a fire or explode!!!
😀

I would say more in regards to DR than HA. In a test environment, QA environment, or demo environment this kind of setup would be very good. For a production environment - not so much.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

forsqlserver (6/8/2011)
But u can use the secondary database as reporting database.

Yes, there would be some benefit there.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Good question

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

c00578 SSChasing Mays Points: 619 More actions · Answer 8

Thanks for another good question. However, I'm not sure about the practicality of this one.

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 9

rfr.ferrari (6/8/2011)
but, with relation the High Availability, forget!!! if my server catch a fire or explode!!!
😀

There are more disasters than a fire or explosion. This can be handy if someone "deletes" a table. A log ship on a delay allow you to recover.

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 10

Steve Jones - SSC Editor (6/8/2011)
rfr.ferrari (6/8/2011)
but, with relation the High Availability, forget!!! if my server catch a fire or explode!!!
😀
There are more disasters than a fire or explosion. This can be handy if someone "deletes" a table. A log ship on a delay allow you to recover.

fire or explosion was only examples!!!! but if crash my hd? if the hardware by anytime fail??

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

Trey Staker SSCarpal Tunnel Points: 4796 More actions · Answer 11

Good question. Thanks.

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum

crashdan SSCommitted Points: 1990 More actions · Answer 12

forsqlserver (6/8/2011)
But u can use the secondary database as reporting database.

The db would be in restore mode in this case, so not able to be accessed the same way. You'd need to replicate in this case.

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 13

rfr.ferrari (6/8/2011)
fire or explosion was only examples!!!! but if crash my hd? if the hardware by anytime fail??

you are missing the point. Log shipping is not just there for handling crashed servers, nor is the implementation here designed to handle everything. It can handle some types of failures, and in a way that real time updates on another server, say mirroring, cannot handle them.

This isn't recommended as the only way to protect your servers, but it is a way to recover from some disasters, namely the disasters that come when someone updates or deletes data.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 14

crashdan (6/8/2011)
forsqlserver (6/8/2011)
But u can use the secondary database as reporting database.
The db would be in restore mode in this case, so not able to be accessed the same way. You'd need to replicate in this case.

We currently logship to a secondary server and set it up so that the secondary is accessible for reads. Works like a charm.

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