September 17, 2002 at 4:25 pm
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
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
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
"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
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
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
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
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