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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-15 : 08:25:55
|
| Ale writes "Dear all, How can i do a simple copy of a complete database in Sql 2000 with all data in the same server and using always Sql 2000 changing only the database name?" |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-10-15 : 09:41:22
|
"Backup and restore". Take a backup of the database and then restore it with the new database name. Look up the Backup and Restore sections in Books OnlineOwais
Make it idiot proof and someone will make a better idiot |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-15 : 14:20:51
|
| Also consider DETACH/ATTACH method. This method is quicker. But this method requires the source database to be offline temporarily. sp_detach_db and sp_attach_db are the stored procedures that you would need to run.Tara |
|
|
|
|
|
|
Copying database on Sql 2000