March 12, 2008 at 3:56 am
Hi all.
I have an issue that I want to be sure of before I start commiting anything.
As of now our database files (*.mdf) and transaction log files (*.ldf) resides on the same physical disks (SCSI RAID). This due to default settings placing files on the same drive + directory. Database is a clustered SQL Server 2005, physically stored on a Fibre channel SAN.
To prevent future disaster I want to move the log files to a different RAID group.
Question is: does detaching + reattaching reset access permissions / database mappings to the respective databases ?
March 12, 2008 at 6:34 am
I beleieve not 100% sure that deattching and re-attching a database on the same server but moving the file locations, will not reults in orphaned db users...The logins will still match db users. So user access will not be affected. This is the case when you restore a db from backup...
If you do need to "fix the sids" then the sp_changes_Users_login sp should be used.
Gethyn Elliswww.gethynellis.com
March 12, 2008 at 7:13 am
Detaching /Attaching on the same server will not orphan users. The users are mapped to SIDs on that instance, so as long as the databases are attached to the same server, there will be a mapping.
March 13, 2008 at 1:32 am
Fantastic.
Thanks a heap for a quick and descriptive answer !
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply