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 |
|
purisqlserver
Yak Posting Veteran
73 Posts |
 Posted - 2002-01-25 : 07:43:20
|
| we have a sql server(1) database accessed by a website. the same database from this is completely transfeerred to another database on different server(2) as a temprorary database. Firstly, the database(temprorary) on the server(2) is met with some house keeping working like updation of prices etc. Now this database on server(2) is again transferred on another database(new) on the server(2). This updated database accessed by another server.How can this task be acheived????Thanx in advance.. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-25 : 12:08:28
|
| There are several ways to transfer a database.See Backup/Restore, Copy Database Wizard, and sp_detach_db, and sp_attach_db.HTH-Chad |
 |
|
|
|
|
|
Data-Maintenance