Post reply

Restoring Databases after system rebuild?

  • May 11, 2006 at 4:28 am

    #366110

    I have a pc with Windows 2000 server as well as SQL server 2000, my databases are also on the system drive (bad pratice, I'm sure!). I need to rebuild the hard drive due to hard drive failures. How would I first backup the databases including all stored procedures, logins etc? then after a new hard drive is fitted and a new build put on restore all the databases back?

  • May 12, 2006 at 8:42 am

    #637590

    Simply issue a backup of the database(s) to a different disk on the server (or totally to another server). Once the new disk is in, simply restore the database(s). Or you can DTS them out and then back in once you're up and running.


    Terry

  • May 15, 2006 at 2:26 am

    #637778

    Thanks Terry, I've managed to do just that

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

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