Restoring a new version of a base already running
- From: bruno.barral@xxxxxxxxxx
- Date: Tue, 25 Sep 2007 02:38:26 -0700
Hello,
I am running a SQL Server 2003 on my PC, with a database nammed
myBase.
I'd like to compare it to another version of the same base, which
seems to be out of date. I have a backup of this other version.
I tried to restore the backup, but I got a message from SQL Server
saying that "A file nammed myBase.mdf already exists and is used, so
the file myBase.mdf cannot be created". Obviously, this is because I
have the recent version of the base already running on the server.
I tried to create a new (empty) base nammed myBase2, and then restore
the backup on it, but I got the same message about the myBase.mdf
file
that already exists. It seems that the myBase.mdf file is contained
in
the backup and has to be created, even if I make the restore in a new
base with a new name.
So my question is : how can I restore the backup of myBase database,
without altering the version of the base which already runs on my
server (this point is very important) ?
Thank your for any hint or help ...
.
- Prev by Date: CommandTimeout?
- Next by Date: Re: Copying tables without data
- Previous by thread: CommandTimeout?
- Next by thread: 2000 vs 2005 performance issue
- Index(es):
Relevant Pages
|
