Forum Replies Created

Viewing 15 posts - 121 through 135 (of 195 total)

  • RE: SQL BACK-UP TIP

    Thank you gus for the knowledge.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • RE: SQL BACK-UP TIP

    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...

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • RE: SQL BACK-UP TIP

    I have not seen any documentation about this.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • RE: DB MIRROR Error

    Apply the most recent transaction log to your mirror server and leave it.If you get the same error to reapply again.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • RE: Back-up strategy

    If I perform the latest full back-up i will not need the previous log back-ups right.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • RE: Back-up strategy

    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...

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • RE: Table space usage 1

    Nice question.Hough difficult for me.Really learnt something thanks.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • RE: Mirroring

    Thank you all,that's the first question i have contributed and like this.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • RE: DB Mirroring question?

    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...

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • RE: DB Mirroring question?

    Oh,I had missed the last part...Thanx.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • RE: Changing Owner or Mirrored DBs

    Remove mirroring and reset again,that is how i do it.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • RE: Changing Owner or Mirrored DBs

    You cant change anything on the mirrored databases.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • RE: Database Mirroring Error with configuration

    Just out of interest,what is the impact of using different ports on different boxes?What difference does it make?

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • RE: Mirroring time out

    You can always increase the timeout.But what is probably more critical is to identify the cause for the time outs.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • RE: Mirroring and Back-up strategy

    Thank you for the advice.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Viewing 15 posts - 121 through 135 (of 195 total)