Viewing 15 posts - 1 through 15 (of 27 total)
its not good for us to loose the 15mts worth of data because once's the Dallas DB server becomes the primary, it starts its record from where the last replication...
July 2, 2013 at 11:54 pm
Please send the error message.
July 2, 2013 at 8:25 pm
May 3, 2013 at 10:14 pm
Is your problem got resolved?
May 3, 2013 at 9:56 pm
Yes it does effect logshipping. To avoid this add both ip's in dns entry to point at sql server and run the ipconfig /flushdns after adding them in dns....
March 15, 2013 at 2:16 am
Thanks for the article. This problem is new to me.
Regards,
Ram
March 13, 2013 at 10:08 pm
Please post the error message.
Regards,
Ram,
MCTS,MCITP
March 13, 2013 at 10:00 pm
Assign db_executor, db_datareader, db_datawriter roles to user.
March 13, 2013 at 9:54 pm
Please provide the results for the below query.
SELECT DB_NAME(DATABASE_ID) 'DBNAME',mirroring_state,
mirroring_state_desc,mirroring_role,
mirroring_redo_queue,mirroring_redo_queue_type,*
FROM sys.database_mirroring
WHERE mirroring_guid IS NOT NULL
Regards,
Ram,
MCTS,MCITP
March 13, 2013 at 9:48 pm
Yes it is possible but why you want to do that when the logshipping already been configured on the same databases?
December 14, 2012 at 6:34 am
There is no default threshold for datbase mirroring send queue or redo queue..
Please share the link you read.
http://msdn.microsoft.com/en-us/library/ms408393.aspx#PerfMetricsAndWarningThresholds
Regards,
RamaSankar
MCTS,MCITP
December 13, 2012 at 3:30 am
Viewing 15 posts - 1 through 15 (of 27 total)