Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Administering » Difference between Physical & Logical...
Add to briefcase

Difference between Physical & Logical instances Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
naveenkumar_segu
Posted Thursday, January 27, 2011 6:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 08, 2012 7:04 AM
Points: 6, Visits: 44
Hi,

I have heard two phrases from someone "Physical & Logical instances". Can anyone please explain me what this is?

Thank you all.


Naveen
Post #1054505
GilaMonster
Posted Thursday, January 27, 2011 6:20 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:18 PM
Points: 37,744, Visits: 30,025
No such thing as a physical or logical instance of SQL. Could be something unrelated. Why don't you ask the person that you heard it from?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1054512
Pouliot Philippe
Posted Thursday, January 27, 2011 6:25 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, May 06, 2013 7:31 AM
Points: 653, Visits: 631
Physcial or Logical exist for Oracle.

1. Physical Standby Database

Standby database is called “physical” if the physical structure of stand by exactly matches with stand by structure. Archived redo log transferred from primary database will be directly applied to the stand by database.

2. Logical Standby Database

Stand by database is called “logical”, the physical structure of both
databases do not match and from the archived redo log we create SQL statements then these statements will be applied to stand by database.

http://www.orafaq.com/node/957
Post #1054516
george sibbald
Posted Thursday, January 27, 2011 6:50 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:32 PM
Points: 5,270, Visits: 11,213
they might have a meant a 'virtual' instance, which is what a sql instance is referred to in a clustered configuration as it could reside on more than one physical node.

---------------------------------------------------------------------
Post #1054536
sqlbuddy123
Posted Thursday, January 27, 2011 10:24 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: Tuesday, May 21, 2013 3:17 PM
Points: 715, Visits: 1,524
Or Could be a Instance on a Virtual Machine Vs Instance on a Physical Machine

Thank You,

Best Regards,
SQLBuddy
Post #1054730
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.