MS SQL Server copy database wizard - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

MS SQL Server copy database wizard

MS SQL Server copy database wizard# Database - 数据库

a*a2003-09-04 07:09

1 楼

Hi,
I have an emergent question about MS sql server copy database wizard.
If you have any suggestion/comment, please let me know. I am waiting...
My situation is:
two sql server 2000 in VPN and I have sysadmin in both db servers.
I am trying to copy one database from one server to another server using copy
database wizard. Everything works fine until I click finish to begin copy, it
stuck there for a long time. It just kill me.
Is there any other method to do this?
Please help me.
auhua

D*N2003-09-04 07:09

2 楼

you can make a backup of the current database, copy it
to the other server, and restore it there.

【在 a***a 的大作中提到】

: Hi,
: I have an emergent question about MS sql server copy database wizard.
: If you have any suggestion/comment, please let me know. I am waiting...
: My situation is:
: two sql server 2000 in VPN and I have sysadmin in both db servers.
: I am trying to copy one database from one server to another server using copy
: database wizard. Everything works fine until I click finish to begin copy, it
: stuck there for a long time. It just kill me.
: Is there any other method to do this?
: Please help me.