Monday, March 19, 2012

Import Data problems

I've setup a new Win2003 server with SQL 2000 server. I'm trying to import
all of the databases, backup jobs, etc.. from another server running Windows
2000 server. When I use the Import Data feature to bring over a database I
get binding errors. Is there an easier way to bring over all of the databases
and settings from SQL2k?
These might help:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
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.sqlservercentral.com/colu...rdatabases.asp
Moving Users
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/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Cwhitmore" <Cwhitmore@.discussions.microsoft.com> wrote in message
news:C35F6CF3-4EFC-4CDB-8A9A-483132C8376E@.microsoft.com...
> I've setup a new Win2003 server with SQL 2000 server. I'm trying to import
> all of the databases, backup jobs, etc.. from another server running
> Windows
> 2000 server. When I use the Import Data feature to bring over a database I
> get binding errors. Is there an easier way to bring over all of the
> databases
> and settings from SQL2k?
>
>

No comments:

Post a Comment