Create a MSSQL7 DB from another

  • I've a MS SQL Server 7.0 up and running, but we need create a copy from this db hurry.

    Server was created but sort order id isn't correct when try to restore master db and now i can't run rebuild utility for copy master copy on new server. We try detach master, but of course... don't work.

    What i should do???

    PD.: Sorry for my english, i'm Panamenian...

  • How about just using DTS to move the data?

    Andy

  • With DTS can't create db users, or not???

  • There is an option to copy sql objects as well. Or you can script them out/in if you're more comfortable with that method.

    Andy

Viewing 4 posts - 1 through 4 (of 4 total)

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