Post reply

Restoring DB to a different drive

  • August 11, 2009 at 7:34 am

    #95978

    Next Tuesday I'm planning on restoring the backup of a very large DB (700 GB) to a new drive mapped to our SANs server.

    Does anyone have any advice on the best way to do this using SQL 2000?

    The plan is to restore pointing the destination to the new drive versus the current DB drive.

    Thanks, Tina

  • August 11, 2009 at 7:43 am

    #1037407

    There isn't any real best way to do this. You point at the new drives in the WITH MOVE statement and let it run. It should run a little quicker on the SAN, but it will still take some time.

  • August 11, 2009 at 7:52 am

    #1037417

    Thank you, that's what I figured. Have never performed a restore so wanted to double-check.

Viewing 3 posts - 1 through 2 (of 2 total)

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