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 - 2006-01-31 : 08:53:22
|
| Ali writes "How can I copy database from SQL server 2000 to SQL server 2005? where is the option in SQLserver 2005 to import/export?thank you" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-01-31 : 08:54:00
|
| Backing up the database and restoring it to the new server is the easiest and probably fastest way to do the job. The BACKUP and RESTORE commands are documented in Books Online. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Copying database