Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Nikolas van Etten 202 posts 162 karma points
    Aug 21, 2009 @ 12:20
    Nikolas van Etten
    0

    Moving ever-growing db to new server with SQL Server Express installed

    Installing umbraco

    One of my v3 sites' db has been growing like crazy and I want to move it to a new server and upgrade it to v4. I know the problem has been described a few places and the solution seems to be either using ClientTools (which will timeout I'm afraid) or running some scripts removing indexes and so on.

    But my main problem is that due to the size of the backup file I cannot import the db into SQL Server Express which is limited to 4GB. I was hoping to avoid messing with the real-time db as this might cause more problems than it solves!

    So does anyone know of a work-around here other than installing a full version of SQL Server? The size of the backup is approx 9,6GB...

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Aug 21, 2009 @ 12:40
    Richard Soeteman
    1

    What I would do to make the current db smaller is the following

    1.  set the recovery model to simple (You'll find that option on the tab options of database properties)

    2. Truncate the umbracoLog table (Not delete)

    3. shrink the database (Right click on database -> Task -> Shrink Database)

     Hope this helps you,

    Richard

    Copy Link
  • Ivan 139 posts 302 karma points
    Jan 04, 2011 @ 14:21
    Ivan
    0

    Richard, te quiero tio ;-) You saved my neck.

    Thanks a lot!

    Ivan

     

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft