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)
 Migration

Author  Topic 

monty
Posting Yak Master

130 Posts

Posted - 2006-10-14 : 09:07:04
Hi Kristen,
We are about to migrate about 100+ databases from one server(SQL SERVER 2000) to other(SQLSERVER 2000).
and we do have a plan 4 the same, i need ur expertize on the best feasible method u would go for,i personally prefer backup/restore to attach/dettach.
following considerations need to be taken into account
1)Less down time or possibly no down time.
2)secured.
3)Less overhead on login trasfers, jobs..


its me monty

Kristen
Test

22859 Posts

Posted - 2006-10-14 : 09:11:04
I suggest having a look through this and seeing if it covers it:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Move%20database,Moving%20to%20a%20new%20sql%20server,Fix%20Orphaned%20Users

Kristen
Go to Top of Page
   

- Advertisement -