Post reply

SQL.LOG

  • September 17, 2002 at 4:25 pm

    #158948

    The SQL server created a file SQL.LOG in my C:\drive I wanted to move the file to another drive and wanted to set the location of the log file.

    Please Help me on the above.

    Thanks,

    Senthil.

  • September 17, 2002 at 4:53 pm

    #436721

    sp_detach is not fould

    The object 'sp_detach' does not exist in database 'master' and other db too.

    I just want to move the SQL.LOG file to different drive and configure Server to write to new drive.

  • September 17, 2002 at 4:55 pm

    #436722

    That would be sp_detach_db. Is SQL.LOG really a transaction log for a database?

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • September 17, 2002 at 5:49 pm

    #436726

    "look @ BOL for an example"

    I could not understand what is BOL Could you PLEASE explain me what it is.

    Thanks.

  • September 17, 2002 at 6:19 pm

    #436727

    BOL means Books onLine. If you are talking about Error Log file, you won't we able to change it with sp_detach_db. You can change it trough the properties of the SQL Server Agent in Enterprise Manager.

  • September 19, 2002 at 10:56 am

    #436886

    SQL.LOG may be created by ODBC Trace, not SQL Server. Check the Tracing tab in your ODBC source. -- Steve

  • September 20, 2002 at 4:15 pm

    #437018

    Is it possible you have Embarcadero tools on your system? One of the option settings references SQL.LOG.

  • September 23, 2002 at 5:54 am

    #437076

    jiangs is right, SQL.LOG is a log file for ODBC processing and can be moved to anywhere by opening Data Sources (ODBC) or ODBC Data Sources control panel appleton the tracing tab. It has little to do with SQL Server, more to do with SQL in general.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply