hi!

i'm trying to copy a database from one server to another. but still
problems persist. here are the details of my servers.

Server A (source)
OS - Windows 2000 Advanced Server
SQL - SQL 2000 Enterprise Edition, Service Pack 4

Server B (destination)
OS - Windows 2003 Server Enterprise Edition
SQL - SQL 2000 Enterprise Edition, Service Pack 4

note: both are in the same domain.

i tried the import/export data. though it has no error messages, but
still it only copies the tables and not the stored procedures and the
views.
then, i tried the copy database wizard. then it generated this error:
"failed to create the share omwwizd".
should the two servers must have the same operating system so that the
copy database wizard would be successful? is there any way that i could
copy the complete database from Server A to Server B?

thanks.

*** Sent via Developersdex http://www.developersdex.com ***

Hi,

SQL Server startup account should have write access in tghe destination
server. My recommendation is :-

1. Backup the database in source server
2. COpy the back file to destination server
3. Restore the database in destination server

This will be faster.

Thanks
Hari

"chanix yahoo" <drchanixx (AT) yahoo (DOT) com> wrote

Try Backup and Restore.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"chanix yahoo" <drchanixx (AT) yahoo (DOT) com> wrote