My suggestion again.

yangn (Raymond)
When using DTS to move the data between two servers, please select the option "transferring objects (not just tables)", which will import both the data and the schema.

The system stored procedure I mentioned is to map the login ID and the database user Id.

If you want to set up the second server which is the standby one for the live server, you have two options:
2)Log shipping.

Both of them can synchronize two servers automatically with some specified delay.

2001-9-8 -05:00

回到话题: 在A电脑上backup一个SQL7数据库,将此备份文件restore到B电脑的SQL上,数据库中的login user会与B电脑SQL中建立的同名login user冲突。何解?或如何在两台电脑间备份恢复数据库?

回到论坛: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论