Forum Replies Created

Viewing 15 posts - 106 through 120 (of 243 total)

  • RE: How to make log-shipped database to be available for queries

    dakshinamurthy (12/31/2008)

    Hi,

    How to make log-shipped database to be available for queries.

    I have MyDB in one Server which is used for Log-shipping and in the other Server MyDB is getting...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 1, 2009 at 12:23 am

    #919905

  • RE: sql job

    kiransuram19 (12/31/2008)

    Hi,

    we have 100 's of jobs in a server and one of the job is not scheduled but it is called from other job(same server job or from different...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    January 1, 2009 at 12:22 am

    #919904

  • RE: FTP command to upload all folderers and subfolders with files

    i can create a single directory or single file but not all

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    December 31, 2008 at 2:55 am

    #919516

  • RE: Deleting temp tables in the system "tempdb".

    Warren Peace (12/30/2008)

    I have some temp tables in my system tempdb that I need to kill.

    They are called #SOMEHEXNumber etc...

    I can not do just a "drop table #SOMEHEXNumber ". I...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    December 31, 2008 at 2:49 am

    #919514

  • RE: Transaction log grows fast

    GilaMonster (12/31/2008)

    This is all-around some of the worst advice I've seen recently regarding transaction logs in quite a while.

    Paresh Prajapati (12/30/2008)

    --Check any transaction is open or not when taking a...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    December 31, 2008 at 1:27 am

    #919488

  • RE: SQL Server taking all the memory 24/7

    raj acharya (12/30/2008)

    hi i want to know that whateever memusage this query shown is that in mb or in kb can u please tell me that

    it is there page...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    December 31, 2008 at 1:23 am

    #919486

  • RE: URGENT: Backup to network device Fail..Operating system error 86.. The specifiednetwork password is not correct.).

    tosscrosby (12/30/2008)

    Brandie Tarvin (12/30/2008)

    But again, he doesn't seem to be listening to that advice.

    BINGO! That's when I signoff on the OP.

    so, what to do?

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    December 30, 2008 at 11:30 pm

    #919454

  • RE: DBA

    seenu_61281 (10/23/2008)

    I would like to be a DBA in sql server.i am little bit stronger in sql queries,sp,views...

    i know basic import/export thru DTS wizard.

    What are the other things i should...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    December 30, 2008 at 11:22 pm

    #919451

  • RE: How to make tempdb use > 1 datafile

    FNS (12/30/2008)

    If a server keeps running out of space for the tempdb one option seems to be, move tempdb to a drive with more space. 😀

    However, what's wrong with just...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    December 30, 2008 at 11:18 pm

    #919450

  • RE: Jobs came up automatically

    iqtedar (12/30/2008)

    thanks everyone for all your answers..

    Rajni..i see the jobs...i do not think msdb is migrated bcoz in the porp it still shows the old date.

    Jonathan..the packages were migrated long...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    December 30, 2008 at 11:17 pm

    #919448

  • RE: Transaction log grows fast

    branovuk (12/30/2008)

    Hi,

    I have one problem with production database. Transaction log is growing fast. I have daily backup. And it worked if I backup log file only, two times, than shrink...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    December 30, 2008 at 11:12 pm

    #919444

  • RE: SQL Server taking all the memory 24/7

    madhu.arda (12/30/2008)

    Hi,

    We have SQL Server 2005 EE x64 a\a\p cluster setup on windows 2003 EE x64.

    Node1 has i insatnce

    Node2 passive

    Node3 Has 4 insatnces.

    We 16 GB RAM on all nodes....

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    December 30, 2008 at 11:04 pm

    #919442

  • RE: How should I diagnose a memory bottleneck in 64-bit?

    DBADave (12/29/2008)

    My mind is mush after reading numerous papers on monitoring memory. Most of what I found was in regards to what DMVs and perfmon/sysmon counters to check, but...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    December 30, 2008 at 11:04 pm

    #919441

  • RE: replication problem

    raj acharya (12/30/2008)

    hi sory please ignore previous one... i want to say that it's replacing your data with old data that because of first step of snapshot taken by process...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    December 30, 2008 at 5:27 am

    #918946

  • RE: Urgent : Problem getting when transfer database backup file on network storage device by FTP

    krayknot (12/29/2008)

    Paresh Prajapati (12/29/2008)

    I have transfer database backup file on network storage device by FTP.

    When i upload backup file on FTP it reduce size of backup file.

    why it happen?

    Bec when...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

    December 30, 2008 at 5:24 am

    #918944

Viewing 15 posts - 106 through 120 (of 243 total)