Forum Replies Created

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

  • RE: How Can I stop SQL Server Service from a job??

    Sadequl Hussain (5/16/2009)


    Instead of stopping SQL Server, there are other options you can take.

    Before the next run of the data run (that increases the log file to fill up the...

  • RE: Rebuild/Reorganize index script

    RPSql (5/16/2009)


    Hi All,

    Now, we have problem with reindex jobs....it takes a lot of time as well as consume a lot of transaction log space to run.

    Probably you are...

  • RE: Getting wiered error in log shipping configuration

    klnsuddu (5/17/2009)


    I think there will be some way to resolve this. Could you please explain me whats the best way I can approach to resolve the issue

    Disable the logshipping, delete...

  • RE: Log Shipping Backup Issue.

    SQL_Monster (5/18/2009)


    But apart from that can't i restore or perform any backups on this db ?

    Sorry, did not get that. You should break the logshipping and start it again. I...

  • RE: Log Shipping Backup Issue.

    That's right ! There is no way that you can synchronise the broken log chain.

    You would have to re configure your Log shipping.

  • RE: Database server is going very slow

    guptaajay1985 (5/14/2009)


    Dear All,

    My Database server is going very slow.Is there any article in SQLServerCentral regarding this? or any suggestions? I have sS2k and ss2k5.

    Step by step process?

    Thanx

    :-PSilly.....

    It's not that easy,...

  • RE: Log file - but what is using it?

    Attila (5/15/2009)


    Thank you,

    Of course I know why the LOG was grown.

    Why?

    But how can it happen that

    -it says 26% (=500MB) used AFTER a tran log backup, while minimal transaction were...

  • RE: Log file - but what is using it?

    Srikanth Anumalasetty (5/15/2009)


    Hi,

    When ever you do a large transaction (Data Load) each and every entry has to go to Log and then to Database.

    Not only a large transaction but...

  • RE: a recently applied update, kb955706, failed to install

    Doctor Who 2 (5/13/2009)


    Krishna Potlakayala (5/13/2009)


    Doctor Who 2 (5/12/2009)


    I'm having the same proble, but not with SQL Server. Its with SQL Server Express 2005. How do I fix...

  • RE: High wait stats?

    Andy (5/13/2009)


    Thanks for your reply Ray.

    There are no complaints and the system is running well. But seeing numbers that high always get me worried as I have no baseline yet.

    Thanks...

  • RE: Log Shipping Backup Settings

    klnsuddu (5/13/2009)


    Hi,

    Firstly,Iam Configuring Log Shipping in SQL Server 2005 and I want to Backup the Transaction log backups to Local to Primary Server.

    If you want to do this you would...

  • RE: Force Kill a session?

    Malcolm Daughtree (5/13/2009)


    J

    rebooting the Server and restoring the databases from the last know "good" backup is all I can suggest.

    No, There is a solution to every problem. OP has to...

  • RE: Force Kill a session?

    psangeetha (5/13/2009)


    Thanks for your reply. There are no databases in suspect mode..

    In the log file viewer, I see 'The operating system returned error 1450(Insufficient system resources exist to complete...

  • RE: BCP in Logshipping servers

    Sundar K. Urs (5/13/2009)


    In bulk logged recovery model, the bulk transactions are minimally logged it't not that they are not logged at all. It only records what extents have changed....

  • RE: Estimating the disk space needed for performing transactional log backups

    shruti.ratnagirish (5/12/2009)


    my d/b is currently in simple recovery mode and we have a full backup every night.

    So, are you ammending your DR plan? May I ask you what made...

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