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