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

I have few doubts, SOMEONE PLZ ANSWER MY QUEESTIONS –Thanks in advanced. Expand / Collapse
Author
Message
Posted Saturday, July 20, 2013 12:19 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 25, 2014 1:24 AM
Points: 339, Visits: 310

Hi All

1. In mirroring If I add data file in primary server will it reflect in mirror server or not?
If yes can you pls explain me?
2. In transactional replication if we get ‘ log file full on subscriber end’ then how to resolve the issue.
3. In transactional replication with updatable subscriber I have added the data file at subscriber end but it is not reflecting at the publisher end.What should I do to resolve it?
4. In log shipping secondary server if we get log file is full then how to resolve the issue.
Post #1475732
Posted Saturday, July 20, 2013 3:06 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 1:47 AM
Points: 53, Visits: 292
rajeshn29.dba (7/20/2013)

Hi All

1. In mirroring If I add data file in primary server will it reflect in mirror server or not?
If yes can you pls explain me?
2. In transactional replication if we get ‘ log file full on subscriber end’ then how to resolve the issue.
3. In transactional replication with updatable subscriber I have added the data file at subscriber end but it is not reflecting at the publisher end.What should I do to resolve it?
4. In log shipping secondary server if we get log file is full then how to resolve the issue.


1. Please refer Gail's comment; Thanks Gail.
2. Do the same workaround as how you will do for other databases. Check the log_reuse_wait_desc column from sys.databases and do accordingly. Ideally you can keep the database in 'SIMPLE' recovery.
3. Refer 1.
4. Shrinking the files in PRIMARY will reflect in SECONDARY in LS/ Mirroring. So shrink the log file in Primary.
Post #1475740
Posted Saturday, July 20, 2013 3:32 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 8:36 AM
Points: 40,615, Visits: 37,080
rajeshn29.dba (7/20/2013)

Hi All

1. In mirroring If I add data file in primary server will it reflect in mirror server or not?
If yes can you pls explain me?


Yes, it'll be reflected just fine. Just make sure that the secondary has the same drive letters as the primary

2. In transactional replication if we get ‘ log file full on subscriber end’ then how to resolve the issue.


Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

3. In transactional replication with updatable subscriber I have added the data file at subscriber end but it is not reflecting at the publisher end.What should I do to resolve it?


Add it at the publisher. Replication replicates data changes, not database structure changes.

4. In log shipping secondary server if we get log file is full then how to resolve the issue.


Log shipping secondary won't run out of log space. The primary might.
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/



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 #1475741
Posted Saturday, July 20, 2013 3:33 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 8:36 AM
Points: 40,615, Visits: 37,080
balasaukri (7/20/2013)
4. Shrinking the files in PRIMARY will reflect in SECONDARY in LS/ Mirroring. So shrink the log file in Primary.


Attempting to shrink a full log is just a waste of time. It's full, there's no space in the file to release to the OS, so why on earth would you try to shrink (release free space to the OS)?



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 #1475742
Posted Monday, July 22, 2013 4:36 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 10:45 AM
Points: 1,058, Visits: 2,696
rajeshn29.dba (7/20/2013)

Hi All

1. In mirroring If I add data file in primary server will it reflect in mirror server or not?
If yes can you pls explain me?
2. In transactional replication if we get ‘ log file full on subscriber end’ then how to resolve the issue.
3. In transactional replication with updatable subscriber I have added the data file at subscriber end but it is not reflecting at the publisher end.What should I do to resolve it?
4. In log shipping secondary server if we get log file is full then how to resolve the issue.


Are they interview questions, too many topics covered.


Regards
Durai Nagarajan
Post #1475927
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse