a*****a 发帖数: 438 | 1 DTS (Start->Program Files->SQLServer->DTS) | c******n 发帖数: 6 | 2 My SQL Server (not Enterprise Edition) has no DTS option, what is that?
domain
The
【在 a*****a 的大作中提到】 : DTS (Start->Program Files->SQLServer->DTS)
| y***e 发帖数: 39 | 3 To register SQL Server B in Enterprise Manager, right click "SQL Server Group"
and click "Register Sql Server..." (cannot remember exact name.)
To back up the database, an easy way is use stored procedures:
sp_dttach_db [dbname]
sp_attach_db [dbname] [filename]
if you don't have active connection on A, you can just find the [dbname].MDF
file and copy it to server A and use sp_attach_db directly. This skips the log
file of course. For details, check out these two commands in Books Online.
Another
【在 c******n 的大作中提到】 : My SQL Server (not Enterprise Edition) has no DTS option, what is that? : : domain : The
| d******o 发帖数: 115 | 4 Remember, you need to redo all your logins too. You need to go to the new
server B, in your attached databases, drop all the old users, create new
logins, and assign them to the databases.
If you don't copy log file, you have to use sp_detach_db to deatch it first.
David Gao
MCSE, MCDBA
Group"
log
problem
B.
B.
【在 y***e 的大作中提到】 : To register SQL Server B in Enterprise Manager, right click "SQL Server Group" : and click "Register Sql Server..." (cannot remember exact name.) : To back up the database, an easy way is use stored procedures: : sp_dttach_db [dbname] : sp_attach_db [dbname] [filename] : if you don't have active connection on A, you can just find the [dbname].MDF : file and copy it to server A and use sp_attach_db directly. This skips the log : file of course. For details, check out these two commands in Books Online. : Another
| c******n 发帖数: 6 | 5 Thank you so much for you guys' help! I detached the database and directly
copy the mdf and log.ldf to the data folder of another sql server. seems
working well :-).
Chris
[dbname].MDF
in
domain
tried
【在 d******o 的大作中提到】 : Remember, you need to redo all your logins too. You need to go to the new : server B, in your attached databases, drop all the old users, create new : logins, and assign them to the databases. : If you don't copy log file, you have to use sp_detach_db to deatch it first. : David Gao : MCSE, MCDBA : : Group" : log : problem
|
|