database question!

Hi,
I need to create a duplicate of a database (with diffent
name) and do some tests on that, i tried to restore it
with different name but didnt work, does anyone know how
to do that.
Thanks in advance-Rob
The RESTORE probably failed because the file names used by the backed up
database are the same as the ones used by the actual database. Use the WITH
MOVE option of the RESTORE command, to specify a different location.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:727a01c4763f$2f6175b0$a601280a@.phx.gbl...
Hi,
I need to create a duplicate of a database (with diffent
name) and do some tests on that, i tried to restore it
with different name but didnt work, does anyone know how
to do that.
Thanks in advance-Rob
|||If the suggestion provided by Vyas doesn't solve your problem, please post
the error message. Without this information, we can only guess on the
solution to your issue.
Hope this helps.
Dan Guzman
SQL Server MVP
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:727a01c4763f$2f6175b0$a601280a@.phx.gbl...
> Hi,
> I need to create a duplicate of a database (with diffent
> name) and do some tests on that, i tried to restore it
> with different name but didnt work, does anyone know how
> to do that.
> Thanks in advance-Rob