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.
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 |

