Tip Details Add a Related Tip

Rate as: Positive Negative

Importing databases in MS SQL

If you are going to import a database into MS SQL, make sure you turn off the transaction logging first. If you don't you will end up with a transaction log that is as large as the database being imported. Depending on the size of the database, this can be a big waste of space.

Turn temporarily turn of the transaction logging in MS SQL in SQL Enterprise Manager, right-click on the database that you are importing to and select "Properties" from this menu. You'll find the setting to turn off transaction logging on the "Options" page.

Once your are done with your import, make sure you turn the transaction logging back on by going through the same process.
Rating: 100% positive, 1 Vote
Categories: databases MS SQL optimization
Added: on May 29, 2008 at 2:47 pm
Added By: an anonymous user

Comments on this Tip

Add a Comment
There are no comments for this tip
Your Comment:
(how to format)
Rate This Tip:

Verify Humanity:
Sorry, we know it's annoying, but please enter the characters shown in the image to the left so that we know you're an actual person and not an evil spammer. Thanks.
       

Related Tips

Minimize round trips to the server for best performance

100% positive, 0 comments
– Tip added by an anonymous user on Jun 18, 2008 at 4:07 pm

Finding slow MySQL queries

100% positive, 0 comments
– Tip added by dbdude on Jun 24, 2008 at 9:22 pm

Speed up Apple Mail

100% positive, 0 comments
– Tip added by an anonymous user on May 07, 2008 at 1:21 pm

Optimize your indexing in Windows Vista

100% positive, 0 comments
– Tip added by frankg on Mar 19, 2007 at 7:30 pm

Getting site contents on mobile devices

100% positive, 0 comments
– Tip added by an anonymous user on Jul 25, 2008 at 6:46 am

Faster indexing in Vista

100% positive, 1 comment - last added on Jun 19, 2008 at 2:34 am
– Tip added by an anonymous user on May 30, 2008 at 10:05 am

Improve GPS signal

Categories: GPS antenna optimization
100% positive, 0 comments
– Tip added by an anonymous user on May 13, 2008 at 8:57 am

Reduce Firefox memory usage in Windows

100% positive, 0 comments
– Tip added by an anonymous user on Aug 01, 2007 at 9:28 am

MySQL Decode Equivalent

Categories: MySQL Oracle databases
no ratings, 0 comments
– Tip added by an anonymous user on Jul 10, 2008 at 5:00 pm

Why you should use MySQL

no ratings, 0 comments
– Tip added by an anonymous user on May 30, 2007 at 10:02 am