Results 1 to 12 of 12

Thread: Truncate transaction log through sql query analyser

  1. 10-20-2005, 09:54 AM #1
    JINIJOSE
    JINIJOSE is offline Registered User
    Join Date
    Oct 2005
    Posts
    6

    Question Truncate transaction log through sql query analyser

    Hi guys

    My website is in asp and sql2000. My problem is the ISP gave access to database through query analyser. some days the transaction log is growing too high. so i want to clear it. i call up them and clear it. My question is can truncate the log file through query analyser ?
    I had limited access to database.

    Jini
    Reply With Quote Reply With Quote
  2. 10-20-2005, 10:46 AM #2
    nosepicker
    nosepicker is offline Registered User
    Join Date
    Dec 2004
    Posts
    502
    BACKUP LOG database_name WITH TRUNCATE_ONLY
    Reply With Quote Reply With Quote
  3. 10-20-2005, 11:04 AM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You'd better to backup log to disk for db recovery purpose.
    Reply With Quote Reply With Quote
  4. 10-20-2005, 02:05 PM #4
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Backup does not reduce the size of the transaction log file, you have to use DBCC SHRINKDATABASE or DBCC SHRINKFILE
    Reply With Quote Reply With Quote
  5. 10-24-2005, 07:13 AM #5
    JINIJOSE
    JINIJOSE is offline Registered User
    Join Date
    Oct 2005
    Posts
    6
    dear skhanal

    It is worked once. but not it not working. the error message returns "please contact your administrator"

    What to do ?

    jini
    Reply With Quote Reply With Quote
  6. 10-24-2005, 09:30 AM #6
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Any error message?
    Reply With Quote Reply With Quote
  7. 10-24-2005, 10:10 AM #7
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Everytime you run DBCC you will see
    "DBCC execution completed. If DBCC printed error messages, contact your system administrator."
    message, so if there is no error then you are fine.
    Reply With Quote Reply With Quote
  8. 10-28-2005, 05:48 AM #8
    JINIJOSE
    JINIJOSE is offline Registered User
    Join Date
    Oct 2005
    Posts
    6
    yes skhanal, you are right.
    err is same. but nothing is happening.

    what to do ?
    Reply With Quote Reply With Quote
  9. 10-28-2005, 09:33 AM #9
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    "DBCC execution completed. If DBCC printed error messages, contact your system administrator." is not error message.
    Reply With Quote Reply With Quote
  10. 11-03-2005, 08:21 AM #10
    JINIJOSE
    JINIJOSE is offline Registered User
    Join Date
    Oct 2005
    Posts
    6
    rmiao,

    then how can i solve my problem ?
    Reply With Quote Reply With Quote
  11. 11-03-2005, 09:17 AM #11
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    What's your problem? Any error message?
    Reply With Quote Reply With Quote
  12. 11-14-2005, 04:59 PM #12
    Delabio
    Delabio is offline Registered User
    Join Date
    Nov 2005
    Posts
    1
    Quote Originally Posted by JINIJOSE
    Hi guys

    My website is in asp and sql2000. My problem is the ISP gave access to database through query analyser. some days the transaction log is growing too high. so i want to clear it. i call up them and clear it. My question is can truncate the log file through query analyser ?
    I had limited access to database.

    Jini
    Backup log to disk for database recovery purpose.
    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