Post reply

Restore failed - insufficient free space on disk volume

  • May 4, 2011 at 7:13 am

    #1319720

    Craig Farrell (5/4/2011)

    Hm, I see where you're going in that case. I'll have to rethink a few things, thank you. The idea of production data on a workstation is bad juju to me, in all sorts of ways. I think my last couple of years of experience has made me data-paranoid.

    That's a good thing. If more people were data paranoid, we would have less issues.

  • June 17, 2011 at 9:00 am

    #1340505

    Have you consider shrinking your database before back it up to release unused space?

    You can do this with DBCC SHRINKDATABASE('DB_Name', TRUNCATEONLY)

    Just note that it is just a solution for the current problem, but it is not a good practice to do shrink before the backup on the regular basis

  • June 17, 2011 at 9:01 am

    #1340506

    Have you consider shrinking your database before back it up to release unused space?

    You can do this with DBCC SHRINKDATABASE('DB_Name', TRUNCATEONLY)

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply