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
Searches: database sql turn transaction

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

Optimize your MySQL database

100% positive, 0 comments
– Tip added by an anonymous user on Dec 07, 2008 at 5:04 pm

Optimizing your MySQL tables

no ratings, 0 comments
– Tip added by an anonymous user on Oct 21, 2008 at 11:18 am

Free up memory on a blackberry

100% positive, 1 comment - last added on Sep 25, 2008 at 9:36 am
– Tip added by bkking on Sep 25, 2008 at 9:15 am

Finding slow MySQL queries

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

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

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

How to reduce load time for your blog or website - BlogPandit

50% positive, 0 comments
– Tip added by an anonymous user on May 24, 2009 at 2:01 am

Speed up iPhoto load time

Categories: iPhoto speed databases
50% positive, 0 comments
– Tip added by an anonymous user on Mar 02, 2009 at 4:03 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

MySQL Decode Equivalent

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

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

Reduce Firefox memory usage in Windows

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

Oracle decode error

Categories: Oracle databases errors
no ratings, 0 comments
– Tip added by an anonymous user on Dec 01, 2008 at 10:08 am

Disable the SQL Server splash screen

no ratings, 0 comments
– Tip added by an anonymous user on Oct 14, 2008 at 8:23 am

Reduce image file size

no ratings, 0 comments
– Tip added by an anonymous user on Oct 06, 2008 at 1:26 pm

Why you should use MySQL

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