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)
 Any one DB move best practice article?

Author  Topic 

aiken
Aged Yak Warrior

525 Posts

Posted - 2003-05-27 : 14:36:28
I'm about to move a very important if-something-goes-wrong-I-get-fired-and-the-company-can't-print-paychecks-anyway database to a brand new server. I've been doing a lot of research, and I think I've got a grasp on it, but I'd really love to find some authoritive single article that covers everything from whether to do detach/attach, synchronizing logins, transferring jobs, full-text indexes, etc.

I believe I've assembled the needed knowledge, but it's an important enough project that I'd really like the additional reassurance .

Cheers
-b

VyasKN
SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2003-05-27 : 14:43:46
I won't say this is authoritative, but I wrote this article a while ago, based on my own experiences: http://vyaskn.tripod.com/moving_sql_server.htm

--
HTH,
Vyas
http://vyaskn.tripod.com
Go to Top of Page

aiken
Aged Yak Warrior

525 Posts

Posted - 2003-05-27 : 16:47:05
Thanks, Vyas. Definitely some good insights there, but unfortunately I'm moving to a differently-configured server, so a lot of it doesn't apply to me. I will keep it handy, though, as it answers a lot of questions.

Cheers
-b

Go to Top of Page
   

- Advertisement -