Copy database for testing on same SQL Server?

I have a live and functioning database on my lone SQL Server 2000. I would
like to create a copy of this database on the same server for when my 3rd
party provider releases updates (SQL scripts) I don't have to immediat3ly
apply them to my live database. If the script causes a failure I want to
discover it on the test database so my users can keep doing their thing.
Is this possible? I've been looking in the Help files as well as scanning
this newsgroup but have yet to discover the solution.
Thanks in advance for your help.Just do a backup of your live database, and then restore it to your
server as a new name, and use the MOVE switch on the RESTORE....see
below
MOVE 'logical_file_name' TO 'operating_system_file_name'
Specifies that the given logical_file_name should be moved to
operating_system_file_name. By default, the logical_file_name is
restored to its original location. If the RESTORE statement is used to
copy a database to the same or different server, the MOVE option may be
needed to relocate the database files and to avoid collisions with
existing files. Each logical file in the database can be specified in
different MOVE statements.
from
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_25rm.asp
Or you could script out everything on your database and DTS all the
data over to new db.|||Thanks for the prompt reply and link. I'll give that a try!
"unc27932@.yahoo.com" wrote:
> Just do a backup of your live database, and then restore it to your
> server as a new name, and use the MOVE switch on the RESTORE....see
> below
> MOVE 'logical_file_name' TO 'operating_system_file_name'
> Specifies that the given logical_file_name should be moved to
> operating_system_file_name. By default, the logical_file_name is
> restored to its original location. If the RESTORE statement is used to
> copy a database to the same or different server, the MOVE option may be
> needed to relocate the database files and to avoid collisions with
> existing files. Each logical file in the database can be specified in
> different MOVE statements.
> from
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_25rm.asp
>
> Or you could script out everything on your database and DTS all the
> data over to new db.
>