June 7, 2011 at 10:29 pm
Comments posted to this topic are about the item Logshipping
June 8, 2011 at 1:56 am
Thank you for the question, good one.
June 8, 2011 at 5:14 am
Yes, but you must log ship to a different database name
Is this correct?
I think Logshipping needs two instances.
June 8, 2011 at 5:17 am
Very interesting :w00t:; especially since BOL describes this feature in a way that one may assume it is not possible.
The clue is--and I would say hidden--in this article, where it states:
The log shipping secondary databases should be on different server instances than either the principal/primary server or mirror/primary server.
Thanks for the lesson,
June 8, 2011 at 6:05 am
is it really functional?
but, the MSDN say different: http://msdn.microsoft.com/en-us/library/ms187103.aspx, directly on first paragraph!
June 8, 2011 at 6:11 am
u can Check it
June 8, 2011 at 6:37 am
forsqlserver (6/8/2011)u can Check it
Can you give me the reference.Where you got it.
June 8, 2011 at 6:40 am
Is BOL scrappy?
Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances.
June 8, 2011 at 6:41 am
I have tested it on test PC.
June 8, 2011 at 6:57 am
i'm sorry, but you are correct!!! i finished the test for log shipping!!! it's really works in same instance with differents databases!
Thanks!! it's a very good question!!!!!
June 8, 2011 at 7:01 am
but, with relation the High Availability, forget!!! if my server catch a fire or explode!!!
June 8, 2011 at 7:04 am
The "correct" answer seems to contradict the question.
June 8, 2011 at 7:13 am
It seems at first that this would be counter-productive, it could be log-shipped to separate disk, yes? You'd still have some shared resources (uh, the instance), but maybe it's a poor man's disaster recovery... 🙂 ?
June 8, 2011 at 7:17 am
But u can use the secondary database as reporting database.
June 8, 2011 at 7:19 am
forsqlserver (6/8/2011)But u can use the secondary database as reporting database.
and have SSRS on same instance of DB???
Viewing 15 posts - 1 through 15 (of 47 total)
You must be logged in to reply to this topic. Login to reply