How to add a new database with a new name by copying an existing datafile?

I want to save a standard SQL Server 2005 Database as a datafile to disk
which I want to add to several other SQL Server at other servers with
another name of the database. What's the procedure to do this? I've been
experimenting with copying the datafiles but SQL Server reponses that the
file names or database name don't match.
regards,
OscarBACKUP the database then use RESTORE WITH MOVE.
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Oscar" <oku@.xs4all.nl> wrote in message
news:Oz0vMUBvHHA.4784@.TK2MSFTNGP06.phx.gbl...
>I want to save a standard SQL Server 2005 Database as a datafile to disk
>which I want to add to several other SQL Server at other servers with
>another name of the database. What's the procedure to do this? I've been
>experimenting with copying the datafiles but SQL Server reponses that the
>file names or database name don't match.
> regards,
> Oscar
>|||You can also use detach / attach.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> pí¹e v diskusním
pøíspìvku news:O6Kj8aBvHHA.3376@.TK2MSFTNGP04.phx.gbl...
> BACKUP the database then use RESTORE WITH MOVE.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> "Oscar" <oku@.xs4all.nl> wrote in message
> news:Oz0vMUBvHHA.4784@.TK2MSFTNGP06.phx.gbl...
>>I want to save a standard SQL Server 2005 Database as a datafile to disk
>>which I want to add to several other SQL Server at other servers with
>>another name of the database. What's the procedure to do this? I've been
>>experimenting with copying the datafiles but SQL Server reponses that the
>>file names or database name don't match.
>> regards,
>> Oscar
>|||> You can also use detach / attach.
Only if it is acceptable for the primary to be offline briefly.|||Hi Aaron,
I want to restore the database within SQL Server Management Studio. I can't
find the 'WITH MOVE' option. It only shows the following settings :
RESTORE WITH RECOVERY
RESTORE WITH NORECOVERY
RESTORE WITH STANDBY
I've tried first to have this done at the same server before I move to
another server :
-made a BACKUP of a resource database
-added a new empty database called TESTCOMPANY
-right click at the database TESTCOMPANY and choose 'RESTORE'
-choose to add from file and select the BACKUP file in the first step
-choose 'OVERWRITE THE EXISTING DATABASE'
Now, in case I set one the 3 listed recovery state, it shows error messages
right in the beginning.
What should I do?
Oscar
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> schreef in
bericht news:O6Kj8aBvHHA.3376@.TK2MSFTNGP04.phx.gbl...
> BACKUP the database then use RESTORE WITH MOVE.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> "Oscar" <oku@.xs4all.nl> wrote in message
> news:Oz0vMUBvHHA.4784@.TK2MSFTNGP06.phx.gbl...
>>I want to save a standard SQL Server 2005 Database as a datafile to disk
>>which I want to add to several other SQL Server at other servers with
>>another name of the database. What's the procedure to do this? I've been
>>experimenting with copying the datafiles but SQL Server reponses that the
>>file names or database name don't match.
>> regards,
>> Oscar
>|||> I want to restore the database within SQL Server Management Studio.
Sorry, this is going to be like trying to swap out RAM through a USB port --
USB is a great technology but it does not cover all the bases, and the same
is true for SSMS. If the paths on the new machine and old machine are not
identical (and they can't be identical on the same machine), you will likely
have to get your hands dirty and learn/use the RESTORE DATABASE command.
A