what would be the best way to copy the entire db to the same server instance?
The only thing is the db name needs to be changed. But the logins, tables,
etc are all the same.
Can't use the wizard since the same instance...
thanx?
Simply restore a full backup and restore it to a different db name and
either place the files on different drives or rename them with the MOVE
option.
Andrew J. Kelly SQL MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:F44B8F48-4635-45AD-844F-473899A5B94E@.microsoft.com...
> what would be the best way to copy the entire db to the same server
> instance?
> The only thing is the db name needs to be changed. But the logins, tables,
> etc are all the same.
> Can't use the wizard since the same instance...
> thanx?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment