Find solution
How to import in mongo database?

How can I import a 46GB database into MSSQL without ending up with a 46GB transaction log?

  • I need to import a database into MS SQL but I do not want to end up with a transaction log as large as the database. What's the best way to do the import? We're working with a software vendor to migrate their database into MS SQL. They set up an ODBC connection to their database and then use Enterprise Manager Data Transformation Services (DTS) packages to copy the tables into an MS SQL database. However, at the end of their test pass we had a 46GB database file and a 46GB transaction log. What's the best way to do this without creating such a giant log?

  • Answer:

    You could set the recovery mode to Simple while you do the DTS.

odinsdream at Ask.Metafilter.Com Visit the source

Was this solution helpful to you?

Other answers

Seconding Lyn. This is what I do.

SPrintF

Have you tried using the http://technet.microsoft.com/en-us/library/ms189275.aspx for the database you are importing into? I'm not 100% sure this will work, but in general the simple recovery mode does not increase the transaction log size. You can set the recovery model back to 'Full' after your import has completed. To change the recovery model, right-click the database in SQL Enterprise Manager, and choose properties. It's on the 'options' page. Of course, IANADBA, but it's worth a shot. On preview... yeah.

pipco

Thanks everyone!

odinsdream

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.