Moving user databases...

Question

Post reply

Moving user databases...

Dexter Plaras

Ten Centuries

Points: 1000
More actions
February 23, 2006 at 12:52 pm

#168471

Hey guys...is it the same steps to move user databases(IE detaching the DB, moving the files and attaching it again) on a clustered active/passive environment to a non-clustered one?
Thanks,
Dex

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 1

yep.

don't forget users and passwords and their synchronisation

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Dexter Plaras Ten Centuries Points: 1000 More actions · Answer 2

Well i'm just planning to move the log files to a different drive for performance on an active/passive sql cluster. do i still need to synchronize users and passwords?

Thanks!

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

So for the sqlserver-instance it's an existing db which will be detatched and reattatched, only having the files at a diffent location.

In that case, the sync is not needed.

What the sync does is mapping the db-user to the server-user. Because they are synchronized because it is an existing db for the server, there is no need to sync again