June 8, 2011 at 1:10 pm
SQLRNNR (6/8/2011)
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.
I stand corrected and learned something!
June 8, 2011 at 1:14 pm
crashdan (6/8/2011)
SQLRNNR (6/8/2011)
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.
I stand corrected and learned something!
Cool
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
June 8, 2011 at 1:30 pm
Steve Jones - SSC Editor (6/8/2011)
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.
what HA the logship offers on same server? what's recommendation of microsoft (BOL)? i agree with you that in determinated situations, i can use or to use the recommended by microsoft in this case accidental deletes or updates, the database snapshot!!!! of course, in SQL 2k5 or later, in another case, i agree totally with you!!!!
June 8, 2011 at 1:47 pm
this haven't important!!! the question is great!!!!!
June 8, 2011 at 2:00 pm
SQLRNNR (6/8/2011)
We currently logship to a secondary server and set it up so that the secondary is accessible for reads. Works like a charm.
What's the process for that? I looked at an online restore in BOL but that doesn't seem like it would work because the filegroup being restored would be offline.
June 8, 2011 at 3:01 pm
cfradenburg (6/8/2011)
SQLRNNR (6/8/2011)
We currently logship to a secondary server and set it up so that the secondary is accessible for reads. Works like a charm.What's the process for that? I looked at an online restore in BOL but that doesn't seem like it would work because the filegroup being restored would be offline.
When setting up log shipping in SQL 2008 you can select either no recovery mode or standby mode. If you select standby mode, you will be able to maintain a read only copy of the secondary database and log shipping will keep it in sync.
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
June 9, 2011 at 7:33 am
Thanks.
June 9, 2011 at 9:04 am
You're welcome.
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
June 9, 2011 at 11:11 am
muthukkumaran Kaliyamoorthy (6/8/2011)
forsqlserver (6/8/2011)
u can Check itCan you give me the reference.Where you got it.
I have tested its working.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 10, 2011 at 9:26 am
A really good question. The discussion has taught me several things.
Tom
June 12, 2011 at 2:38 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 18, 2011 at 5:24 pm
I test publishers and subscribers the same way in testing, on the same instance. Only mirroring requires multiple instances since the database name must be identical.
Great question!
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
June 21, 2011 at 3:20 pm
The answer should be no. Of course you can log ship to another database on the instance, but this was a simple yes or no question. Give points for no please. The exact questions states whether you can log ship to the SAME database on the instance called 'test'. A simple NO is the answer. There is no reason to put that D answer out there because it does not answer the question as asked.
Thanks.
June 21, 2011 at 5:30 pm
Dude63 (6/21/2011)
The answer should be no. Of course you can log ship to another database on the instance, but this was a simple yes or no question. Give points for no please. The exact questions states whether you can log ship to the SAME database on the instance called 'test'. A simple NO is the answer. There is no reason to put that D answer out there because it does not answer the question as asked.Thanks.
I suggest you read the question again, paying more attention to what it says. "a database on the same default instance" does not mean the same as "the same database on the same default instance". The question has the former. You appear to have interpreted it as the latter.
Tom
June 21, 2011 at 8:24 pm
Dude63 (6/21/2011)
The answer should be no. Of course you can log ship to another database on the instance, but this was a simple yes or no question. Give points for no please. The exact questions states whether you can log ship to the SAME database on the instance called 'test'. A simple NO is the answer. There is no reason to put that D answer out there because it does not answer the question as asked.Thanks.
I also think you've mis-read this, especially given the answers, but I can see the way you interpreted it. I've altered the verbiage to somewhat clear things up.
Viewing 15 posts - 31 through 45 (of 47 total)
You must be logged in to reply to this topic. Login to reply