Forum Replies Created

Viewing 15 posts - 676 through 690 (of 860 total)

  • RE: HELP PLS :( What does "Error: 644, Severity: 21, State: 3" means and how can I fix it?

    elay (2/18/2009)


    ====================================================

    Event Type:Error

    Event Source:MSSQLSERVER

    Event Category:(2)

    Event ID:17052

    Date:02/18/2009

    Time:6:43:38 PM

    User:N/A

    Computer:RETAILIGENCE

    Description:

    Error: 9001, Severity: 21, State: 1

    The log for database 'Retailigence' is not available.

    Data:

    0000: 29 23 00 00 15 00 00 00 ...

  • RE: what permission is needed to run Management Studio?

    any member can run SSMS, even a member without login using guest account. It really depends on what the member is and what job he is going to perform on...

  • RE: script error

    srimkumarp (2/19/2009)


    thanks for reply krishna,

    yesterday night we restarted the system. Automatically all applications back to normal now.

    That's good! But that's an interim solution it's not a permanent fix. You...

  • RE: Maintenance plans

    No, you don't have to. But, What is the real issue?.

  • RE: BCP Vs Bulk Insert

    BOL is the best choice to start with:)

  • RE: script error

    srimkumarp (2/18/2009)


    one day i monitored the same max no of user connection using performance conunter is

    313 @ 1:13 pm

    282 @ 3:32 pm

    Even early morning only 120 connection are...

  • RE: SQL Agent Job

    Would you be able to provide more information on the error you are receiving? Check your Error log and can you provide the deatails?

  • RE: SQL Agent Job

    ssismaddy (2/18/2009)[/b

    Executed as user: Name\LoginName. Invalid object name 'tlcspifitems'. [SQLSTATE 42S02] (Error 208). The step failed.

    Well, it says its an invalid object name. Have you checked whether the object...

  • RE: Question about backups

    shri_sastry (2/18/2009)


    Hello All,

    I would like to test if my backup scripts are working correctly and if I am able to restore from the backup.

    Do you have a test/development server?...

  • RE: My LDF file grew to 180GB - How do I shrink it

    So, Do you send snapshots to your sales people?

  • RE: script error

    srimkumarp (2/18/2009)


    the max total no of connections 387 using sp_who2.

    No you have to monitor for 24 hours as a counter value SQL Server:General Statistics:User Connections for continuous periods of 10...

  • RE: script error

    srimkumarp (2/18/2009)


    from network point of view i have just ping the both servers.

    appliction server some times it reaches 15 ms other than normal.

    how about the User connections at those times?

  • RE: script error

    srimkumarp (2/18/2009)


    thanks for ur reply,

    daily i am viewing the results of sp_who2,sql profiler and system monitor.i never observed blocking.

    While observing did you notice any network bottlenecks?

  • RE: script error

    srimkumarp (2/17/2009)

    Applications are running very slow after 6:30 pm to next day 2:30 pm.

    you should check whats happening within your server within this time?

    As advised first I would start with...

  • RE: My LDF file grew to 180GB - How do I shrink it

    We haven't heard anything from the OP as of yet. So, We cannot really say Simple Recovery Model would be suffice. IF you look at the posts we have given...

Viewing 15 posts - 676 through 690 (of 860 total)