transaction logs.......

Results 1 to 2 of 2

Thread: transaction logs.......

  1. #1
    Join Date
    Dec 1969

    Default transaction logs.......

    i have win2k server with sql 2000. I create db in sql whihc have the default db and log file path(c:progr..mssql...).And i disable the autogrowth of sql logs while creating a databse. And the asp for that databse gives a transaction log full error. I back up the log to D:sqllogbackup. But the log doesnt clear. THe asp still give the log full error. I am forced to increase the log space then everything works fine. Whats going wrong here? Cant afford unrestricted growth due to space constraints.<BR><BR>help please<BR><BR>brij <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: transaction logs.......

    backup up the log *and* specify the &#039;TRUNCATE LOG&#039; option<BR><BR>(WITH TRUNCATE ONLY in T-SQL)

Posting Permissions

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