I've been moving SQL Server databases from one array to a new, freshly created drive array. I've managed to move all the user databases successfully, but when it came to the system databases, I misread the Microsoft "How To" document on moving system databases.
I successfully stopped and restarted SQL with the traceflag 3608, detached model, msdb and a database containing the newly migrated Analysis Services Repository; I then copied the data files (.mdb & .ldb) to their new home (note: all datafiles still exist in the original location - and I took a SQL backup of all databases before starting); unfortunately I missed the next step, which would have been to reattach the databases to SQL and instead blundered on to stop SQL, remove the trace flag and fire it up again. Obviously, it doesn't work.
So, I now have a situation where I can't do anything with SQL server because it resolutely refuses to have anything to do with me. I'm sure that all I need to do is (somehow) reattach msdb (don't care where from), and start up SQL - but I don't know how - and searching the Microsoft site has revealed an awful lot about backup/restore - but that's not what I want or need to do (I suspect).
Can you point me in the right direction?
January 3, 2006 6:53 AM
January 5, 2006 5:39 AM