Home / server / Questions / 259842
Accepted
contactmatt
Asked: 2011-04-15 12:25:56 +0800 CST

Sql Server 2008 - Use OSQL utility to shrink files and then log result

  • 772

I'm running batch processes via a batch file and I want SQL server to log the reslt when I execute my DBCC SHRINKFILE command from my batch file. Is there anyway to do this?

Example: - Run.bat

rem Shrink transaction log and log the result

"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\osql.exe" -E -Q "Use [Database] DBCC SHRINKFILE(Database_log, 50)"
sql-server sql-server-2008 utility osql

1 Answers

  1. Best Answer

    If you're just trying to log it to a text file you can do something like the following:

    "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\osql.exe" -E -Q "Use [Database] DBCC SHRINKFILE(Database_log, 50)" >> C:\ShrinkFile.LOG

    The >> will append or > to overwrite.

    If you want SQL server to actually log it in the error log then I would suggest looking into a trace flag that would handle that.

    • 3