Viewing 15 posts - 121 through 135 (of 194 total)
Ok,Server A(Back-up Source)...OS Win Server 2008 R2,SQL Server R2
Server B (Back-up Destination)...OS Win Server 2008 R2,SQL Server R2
Machine C(My workstation)...OS Win XP SP3
1.log on remotely on A and back-up on...
January 11, 2012 at 7:35 am
Apply the most recent transaction log to your mirror server and leave it.If you get the same error to reapply again.
January 11, 2012 at 6:47 am
If I perform the latest full back-up i will not need the previous log back-ups right.
January 4, 2012 at 2:14 am
What's wrong with running a maintenance plan thats does log back-ups for my databases and store in a folder on the same machine.If I were to burn the log back-ups...
January 4, 2012 at 12:11 am
Nice question.Hough difficult for me.Really learnt something thanks.
November 9, 2011 at 1:51 am
Thank you all,that's the first question i have contributed and like this.
November 4, 2011 at 4:30 am
It depends with how your application connects.If you are using SQ L Server native client,it will know that the server has changed.Otherwise you will have to manually change the connection...
October 20, 2011 at 4:04 am
Remove mirroring and reset again,that is how i do it.
October 20, 2011 at 2:11 am
You cant change anything on the mirrored databases.
October 20, 2011 at 2:10 am
Just out of interest,what is the impact of using different ports on different boxes?What difference does it make?
October 20, 2011 at 2:08 am
You can always increase the timeout.But what is probably more critical is to identify the cause for the time outs.
October 20, 2011 at 2:06 am
Viewing 15 posts - 121 through 135 (of 194 total)