copying databases from one server (win2K) to another (win2k3)

Hello All,
I am a SQL server newbie, so please try to answer in simple terms. I
am trying to copy databases from a SQL 2000 (Win2k) to another SQL
2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
getting the familiar "Failed to create OMWWIZE share" error.
I've set up my source server to start up with the 'System Account' and
my destination server to start up with my Windows account that has
administrative privileges on that machine.
After reading up on several froums, SQL Server Books online...I came
to know that backup/restore is a wonderful option, but I don't have
the same drive specifications on the two servers and also need some
step by step instructions on how to back up the databases on the
source server and restore the same in the destination server.
Thanks to you all in advance for the help.
Ram.I think that wizard causes more problems than it solves. Have a look at
these:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.com...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.|||Easiest way is probably to restore a backup to the other server
or detach/attach
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?kbid=314546
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071
For tips on using the Copy database wizard
INF: Understanding and Troubleshooting the Copy Database Wizard in SQL
Server 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463
Also check out
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274188
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.com...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.