Forum Replies Created

Viewing 15 posts - 151 through 165 (of 167 total)

  • RE: logshipping db readonly mode

    Manually I created logins with same passwords in secondary server. I totally configured secondary server same as primary server. and had setup logshipping for user databases(restored user db's in standby...

  • RE: logshipping db readonly mode

    No. but same logins and permission are in DR server whatever production has

  • RE: connection error

    chk2009 (11/13/2009)


    Steve Jones - Editor (11/13/2009)


    The error shows you are connecting with named pipes. You might have something changed in your SSMS connection dialog. Double check all settings that you...

  • RE: connection error

    Steve Jones - Editor (11/13/2009)


    The error shows you are connecting with named pipes. You might have something changed in your SSMS connection dialog. Double check all settings that you are...

  • RE: connection error

    Steve Jones - Editor (11/13/2009)


    HOW are you connecting? SQL Auth, Windows Auth, what are you typing in SSMS? That is some of the information we need to help you solve...

  • RE: connection error

    We have two servers

    production and DR server(planning to set up logshipping)

    In both servers sql server std edition is installed, both are in same workgroup and no firewall and all...

  • RE: connection error

    Steve Jones - Editor (11/12/2009)


    It's a connection issue as stated. Can you connect from another workstation/client? Are you allowing connections remotely? What protocol are you using, and how are you...

  • RE: SQL select statement results to XL file

    lmu92 (11/10/2009)


    What do you mean by "XL file"?

    Is it a typo meaning XML structure or do you want to store an "eXtra Large" file?

    If the former, please search for "XML...

  • RE: Tail backup

    Paul White (11/10/2009)


    chk2009 (11/10/2009)


    Can we take tail tlog backup even when db is offline/damaged/correpted

    Yes. Tail Log Backups

    Thanks for your reply:-)

    How can we do that, can you pls explain me in...

  • RE: Tail backup

    Can we take tail tlog backup even when db is offline/damaged/correpted

  • RE: SQL Pager alerts

    Lynn Pettis (11/3/2009)


    People still have pagers??

    If you already have the pager(s) check with the company and see if you can send email alerts via them. Many years ago at...

  • RE: CPU reached 100%

    Thank you -CirquedeSQLeil and Gila monster

    Issue has been resolved.

    One windows service is taking more memory. This service runs daily 12Pm, basically it connects to external client system it downloads ftp...

  • RE: CPU reached 100%

    @CirquedeSQLeil

    No jobs are failed

    No blockings

    No long running queries

    I checked perfmon counters. Pages/sec and avg disk counters reaching to 80-100 some time.

    @gila master

    Thanks for your reply, yes I want to reduce...

  • RE: load testing

    @Marcin Gol

    Thank you for reply.

    If you can provide the steps/process using Benchmark Factoy tool, I appriciate it. Thanks once again

    I need to test SQL Database performance and user...

  • RE: load testing

    @free_mascot

    Thank you for your reply.

    Can we capture user connection load with SQL Profiler, if so please let me know the how to capture.

    ----

    And I came accross a solution,...

Viewing 15 posts - 151 through 165 (of 167 total)