Forum Replies Created

Viewing 15 posts - 91 through 105 (of 195 total)

  • RE: Transactions 2

    Nice question i got it correct,i encountered a similar experience.I liked the explanation learned something.thank you.

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

  • RE: Braking a Mirror

    No issue I have done this before.If break the mirror with the intention of re-mirroring,just lookout for the configurations,if you had used certificates make sure they are secure or you...

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

  • RE: Select Statement

    Thank you,an easy one.

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

  • RE: DBCC CHECKDB

    Nice question though i got it wrong,learnt something.

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

  • RE: Foreign key

    Nice and trick question,thank you.

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

  • RE: Endpoints

    @ Koen Verbeeck, Thank you for the further information.

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

  • RE: Offsite Warm Backup

    Alright,I get your point now.

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

  • RE: Offsite Warm Backup

    'The problem with mirroring is that they use Standard, not Enterprise'...you can mirror in both these editions.

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

  • RE: SQL Server Agent Job History

    Thank you.I have msdb backups only for this year not for the period that I want.Why would I need backup covering the actual period?Is the information stored in the tables...

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

  • RE: DBA Tasks

    Back-ups and Integrity you can use maintenance plans.

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

  • RE: how can i use the mirrored database? help plz

    Why would you want to restore a database in a mirroring session?I would suggest creating a new database and restoring on the newly created database ,unlike removing the mirroring session...

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

  • RE: SQL Agent Schedule being missed

    Also keep track of the time the job is taking to complete execution.

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

  • RE: Offsite Warm Backup

    Yes,log shipping but this also heavily depends on the recovery point time and the recovery point objective for your company.Otherwise i would advice mirroring and you address the latency issue.

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

  • RE: Mirroring for a database with partitioned tables

    Thanks for the article so helpful.

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

  • RE: SQL Server DBA learning Oracle

    You can also find an application that uses an oracle database for training purposes.It dd help me a great deal.

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

Viewing 15 posts - 91 through 105 (of 195 total)