Results 1 to 12 of 12

Thread: why some of my database suddently unavailable

  1. 08-07-2005, 11:08 PM #1
    sql
    sql is offline Registered User
    Join Date
    Jul 2003
    Posts
    421

    why some of my database suddently unavailable

    Hi all,
    One of my databse suddently unailable(suspect)
    , I have automatic back up plane and I can backup it , but can any one tell me why??
    Thank you
    ________
    Volcano Vaporizer
    Last edited by sql; 03-06-2011 at 01:46 AM.
    Reply With Quote Reply With Quote
  2. 08-07-2005, 11:19 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Look in the errorlog, eventlog. You may have lost your drives.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 08-08-2005, 12:56 AM #3
    sql
    sql is offline Registered User
    Join Date
    Jul 2003
    Posts
    421
    HI Mak,
    I don't found any useful information in evenLog, is there any artical tell people how to found useful information in error Log??
    By the way I found some information like
    Login succeeded for user 'test'. Connection: Non-Trusted.
    2005-08-05 12:12:07.65 logon Login succeeded for user 'test'. Connection: Non-Trusted.
    2005-08-05 12:12:07.67 logon Login succeeded for user 'test'. Connection: Non-Trusted.
    2005-08-05 12:12:07.67 logon Login succeeded for user 'test'. Connection: Non-Trusted.

    What is the Connection: Non-Trusted.mean?
    I have an interface connection to database.
    Thank you
    ________
    MERCEDES-BENZ WORLD SPECIFICATIONS
    Last edited by sql; 03-06-2011 at 01:46 AM.
    Reply With Quote Reply With Quote
  4. 08-08-2005, 08:23 AM #4
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Non-trusted means you are using SQL login as opposed to windows authentication.

    Windows system/application log may have more information on hardware failures.
    Reply With Quote Reply With Quote
  5. 08-08-2005, 10:06 AM #5
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    If it's sql server, most likely the server has disk related problem. Check windows system event log for disk related messages.
    Reply With Quote Reply With Quote
  6. 08-09-2005, 12:57 AM #6
    sql
    sql is offline Registered User
    Join Date
    Jul 2003
    Posts
    421
    > Non-trusted means you are using SQL login as opposed to windows authentication
    yes! the connection come from interface and use password and useer name that store in database.
    > Windows system/application log may have more information on hardware failures.
    are you taking about the even Viewer ->application, I can't found anything in there.
    >system event log
    where ?
    Thank you
    ________
    HAWAII MARIJUANA DISPENSARY
    Last edited by sql; 03-06-2011 at 01:46 AM.
    Reply With Quote Reply With Quote
  7. 08-09-2005, 09:07 AM #7
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Event view -> system.
    Reply With Quote Reply With Quote
  8. 08-10-2005, 09:52 PM #8
    sql
    sql is offline Registered User
    Join Date
    Jul 2003
    Posts
    421
    Hi all,
    Happen, but found nothing in Even-> system too, Is different even Id show some thing, what even id show hard driver fail? I go to Disk manage is seems all my disk are health?
    why??
    ________
    Toyota corona
    Last edited by sql; 03-06-2011 at 01:48 AM.
    Reply With Quote Reply With Quote
  9. 08-11-2005, 08:23 AM #9
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Are your dbs still in suspect status? Event number depends on array type used. By the way, do you have server management tool on your network? What kind of server and disk array used?
    Reply With Quote Reply With Quote
  10. 08-11-2005, 09:20 AM #10
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Ask your system admins to run Diagnostics tool provided by the server vendor, this can uncover things that Windows can't detect.
    Reply With Quote Reply With Quote
  11. 08-11-2005, 10:28 PM #11
    sql
    sql is offline Registered User
    Join Date
    Jul 2003
    Posts
    421
    hi all,
    some of my database in suspect, recently, I back up thenand don't why?It seem too complicate for me to handle.
    Thank you
    ________
    WEED VAPORIZER
    Last edited by sql; 03-06-2011 at 01:48 AM.
    Reply With Quote Reply With Quote
  12. 08-15-2005, 10:01 AM #12
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Caused by disk related problem in most case, should work with your system admin to pin point the root cause.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules