Copied to clipboard

Flag this post as spam?

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

  • Debbie Lawrenson 55 posts 75 karma points
    Oct 30, 2013 @ 15:45
    Debbie Lawrenson

    Changing DB name and associated user


    I am having a bit of a headache here! I am a newbie STILL and trying to get my first site live. Problem is that I used my Umbraco training site as the basis for my first site and left the DB name as UmbracoTraining. Then when I uploaded my files to the live server I created a DB with a different name and different user and now I'm trying to restore the UmbracoTraining.bak on top of the new DB. This isn't working. Is there any way to sort this out so that I can keep the new DB name and user (don't really want to have the client's DB called UmbracoTraining and I don't really want it to have my master username and password either).

    Any help would be great. I will get the hang of this at some point!!

    Also any suggestion of how I should have done it to avoid all this agro!



  • Dan Lister 415 posts 1970 karma points c-trib
    Oct 31, 2013 @ 13:33
    Dan Lister

    You shouldn't need to create a new database to restore your backup over the top off. Remove your new one and use the 'Restore Database' option in sql server management studio. You'll be able to specify the new database name using this option.

Please Sign in or register to post replies

Write your reply to: