Forum Replies Created

Viewing 15 posts - 181 through 195 (of 195 total)

  • RE: Poor Performance

    Sure Gila, thanks that was a million tons ausome Advise for a fresher like me 🙂

  • RE: Poor Performance

    Thanks Gila 🙂

    But one more question..

    Will the EXEC sp_updatestats; & EXEC sp_recompile 'sp_name';

    help to fatser the performance?????

    How should i go ahead and use it .. i mean whne thier is...

  • RE: Log Shipping & DataBase Mirroring

    Perry Whittle (8/29/2012)


    runal_jagtap (8/28/2012)


    if it runs correct then the same setup needs to be done in accordance to Production...

    😀

    Log Shipping is not a new feature, it's solid and robust and...

  • RE: Log Shipping & DataBase Mirroring

    MissTippsInOz (8/29/2012)


    runal_jagtap (8/28/2012)


    I cannot question the client directly as to what he is up to.. its just that i am asked to learn and implement LS on Test servers &...

  • RE: Log Shipping & DataBase Mirroring

    I cannot question the client directly as to what he is up to.. its just that i am asked to learn and implement LS on Test servers & if it...

  • RE: SQL SERVER Performance

    GilaMonster (8/28/2012)


    Seriously, if this is a critical problem and you don't have any knowledge of performance tuning, get someone in to help.

    Hi Gail,

    Na its not that serious as of now.....

  • RE: SQL SERVER Performance

    Thanks All 🙂 i will follow your answers :-):-)

  • RE: SQL SERVER Performance

    I dont know the exact query.. but the network team says that its a DB issue & you should look into it..

    How do i confirm whether its a DB issue...

  • RE: Restore Database

    Divine Flame (8/28/2012)


    greeshma.patla (8/28/2012)


    Hi ,

    I Dont have .mdf and .ldf files tooo 🙁

    I have only Transaction Log file and Data File

    Is it possible to restore db ?

    Please ...

  • RE: Restore Database

    greeshma.patla (8/28/2012)


    Hi ,

    I Dont have .mdf and .ldf files tooo 🙁

    I have only Transaction Log file and Data File

    Is it possible to restore db ?

    Please help...

  • RE: Restore Database

    anthony.green (8/28/2012)


    Yes, lookup sp_attach_db in BOL or a search engine of your choice.

    Yes, this is also another way you can try which anthony said.....

    Here you go with an example..

    EXEC sp_attach_db...

  • RE: Restore Database

    I am new here as a DBA, but i think restoring wont work here.. instead you can right click on DATABASE and then select Attach Option & there you can...

  • RE: Store procedure help

    Hi all,

    I made it... it got solved with slight modifications... Thanks al:)

  • RE: Log Shipping & DataBase Mirroring

    Thanks Gila & Divine 🙂

    Will try out the steps but what should i be ready with apart from the steps???

    I have got system with Enterprise edition & two servers to...

  • RE: Log Shipping & DataBase Mirroring

    Hi Gila,

    Thanks for the quick reply, i do have some stuff's and links..

    I am not sure whether the link is complete solution....

    http://www.mssqltips.com/sqlservertip/2301/step-by-step-sql-server-log-shipping/

    1) Can you tell me whether the...

Viewing 15 posts - 181 through 195 (of 195 total)