Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2003
    Location
    Delhi INDIA
    Posts
    58

    Question Unanswered: sql database without log file..???

    hi all,

    I have been asked a question that, can we run a sql database 7 or 2000 without having a log file...

    is it possible to do so ???.. if yes then what is the way and limitations of it.

    pls reply, your hints and solutions will help me a lot.

    Cheers!!
    Deep..

    MCDBA
    ------------------------------------------
    How much data you can afford to lose??

  2. #2
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149
    Don't think it is possible to have a SQL Server database without a logfile

    You can set up you database to have minimum ammount of logging
    Look up recovery models on books online

    You propably want the simple recovery model which has the least amount of logging of transactions to log

    hth..

  3. #3
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    You cannot run a SQL Server database without a log file. The log file has to be there to ensure database integrity. You can however do what the previous post suggests to keep the size of the log file to a minimum. It should be noted, however, that this will not reduce the amount of logging that your database will do - it will simply keep the log file smaller.

    Hope this helps
    Regards
    Dbabren

  4. #4
    Join Date
    Dec 2003
    Location
    Delhi INDIA
    Posts
    58
    well, after putting my database on read only mode can we delete my log file by any ways....
    reason:- once my db will be in read only mode NO transaction will be logged in log file, hence we will no more require the log file.

    is it posible to delete log file from db when it is in read only mode... and db is runing..


    Need your expert answer!!

    Cheers..
    Deep..

    MCDBA
    ------------------------------------------
    How much data you can afford to lose??

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    As explained database in SQL Server has at least one data file and one transaction log file. Data and transaction log information is never mixed on the same file, and individual files are used by only one database.

    Its not possible to delete the Tlog file, if so database will be in suspect mode.

    Instead you can obtain SIMPLE recovery model and define certain size to the database and continue to perform FULL database backups at regular intervals.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  6. #6
    Join Date
    Dec 2003
    Location
    Delhi INDIA
    Posts
    58
    THANKS A LOT TO GIVE ME YOUR VALUEABLE TIME...

    I TRIED A LOT TO DO SO BUT ALL IN ALL "FAILED TO DO SO"


    Best Regards....
    Deep..

    MCDBA
    ------------------------------------------
    How much data you can afford to lose??

  7. #7
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    What you've tried and where it failed?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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