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 -04:00
This post has been archived. It cannot be replied.
Page address has been copied. To share, click to copy page address.
Share Online by QR Code

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

Back To Forum: HOME枫下论坛枫下论坛主坛工作学习IT技术讨论