Announcement

Collapse
No announcement yet.

Microsoft][ODBC SQL Server Driver][SQL Server

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Microsoft][ODBC SQL Server Driver][SQL Server

    hi,

    we have an sbs 2008 server and I have been allocated this problem to fix. I don't know much about sql so would appreciate some help.

    we get this error when a backup is run

    Microsoft][ODBC SQL Server Driver][SQL Server]The transaction
    log for database 'test' is full. To find out why space
    in the log cannot be reused, see the log_reuse_wait_desc column
    in sys.databases


    how do I troubleshoot this?

    thanks.

  • #2
    Re: Microsoft][ODBC SQL Server Driver][SQL Server

    Is SQL Server Management Studio installed on the server?
    If so, go into it, connect to the local database server and locate the "test" database
    Go into database properties then go to the FILES page
    Tell us what the log options are and increase the size anyway

    If SSMS NOT installed, please post back
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Re: Microsoft][ODBC SQL Server Driver][SQL Server

      there is 176 gb free on the C drive.
      which setting do I change to increase the log option?
      thanks,
      Attached Files

      Comment

      Working...
      X