Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to Copy a db on same server?

Author  Topic 

mutlyp
Starting Member

20 Posts

Posted - 2010-11-15 : 13:56:31
Hello
I am using SQL Server 2003 and SQL 2000. I have a database that I want to make an exact copy of to use as a test database. How can I make an exact copy of a database that sits on the same server as the original?
Thank You
Mutlyp

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2010-11-15 : 14:58:47
not sure what SQL Server 2003 is. easiest way to do what you need is backup/restore.


elsasoft.org
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-15 : 19:06:53
Also, when you use backup/restore, you'll need to specify the WITH MOVE option so that you don't collide with the source database's files. If you use the RESTORE wizard, you'll find the option on the second screen.

Either specify a different path or different file names.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -