Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DATA MIGRATION FROM ONE SQL SERVER TO ANOTHER

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-22 : 10:10:07
Andris writes "I wan to install SQL Server 2000 on a WINNT Server and I have 2 databases: members (+members.ldf) and orders (+orders.ldf) tooken from another SQL Server 2000.

I know tha there could be probles migrating data between servers with different configuration options. The problem is that I don't know this opions of the SQL Server, from which I have this 2 databases.
Could I detect this server settings using this two databases and then install SQL Server on my server?
The problem is that I also can't contact that SQL Server administrator, but these database I should install as soon as possible.

Please help me if You know the ansver.
Andris"

Nazim
A custom title

1408 Posts

Posted - 2002-01-22 : 10:35:07
look for sp_attach_db in BOL


--------------------------------------------------------------
Dont Tell God how big your Problem is , Tell the Problem how Big your God is
Go to Top of Page
   

- Advertisement -