How can we help you today? How can we help you today?

SQL Data Compare creates a large log file.

I am moving data from an older database to a newer, after I run the data compare, the *_log.ldf is 2x larger than the *_data.mdf file. Is this normal and how can I reduce the size of the log file?

I am running SQL Express 2005.
cirrussoftware
0

Comments

2 comments

Sort by
  • Robert C
    Hi,

    If you're changing a lot of data, yes, this doesn't sound too unusual. The reason for this is that with the default options, SQL Data Compare makes all changes within a transaction. This means that if anything goes wrong, it can roll everything back and leave the database as it was before the attempt.

    You can disable the use of transactions in the project "Options" tab - under Synchronization Behaviour, there's an option for "Use transactions in SQL scripts". However, if an operation does fail, the database may be left partially synchronized.

    Alternatively, there's documentation on how to shrink a log file that's grown beyond what you'd normally need at MSDN.

    Hope that helps,
    Robert
    Robert C
    0
  • cirrussoftware
    Thanks that worked.
    cirrussoftware
    0

Add comment

Please sign in to leave a comment.