Mn Daisys Patch Placement

Attach / Detach manual

The process of online / off line or attach / detach a database (very useful sometimes) is a feature appeared from 2008.
forces in 2005, big concerns for this operation, hence my problem today: the relocation of an AS 2005 instance in which only the data disks from the old forum have been kept (with the directory. "Db" is it already): Of course, we want to recover these bases that we do not have backups (only directories containing the data file).

If you manage your instances of 2005 with SSMS 2008, actually, in the menu there are many possible make a Detach your database: all you say right away that it does not work.

So two options: Either you

• change in the configuration file of your instance AS datadir property by filling in the directory that contains your old data, then restart the instance to reflect this change, then backup databases, then re-change the datadir directory path with initial data, then re-start the instance and finally a newly created Restore backups. The cleanest method, but heavy, especially if you have 20 bases up to back then.
• EITHER method, a little more brutal but saves time: copy and paste the old directories. "db" XML files ". db.xml", and the master.vmp CryptKey.bin in your data directory Current, a restart of the instance and voila. Of course, this works with an instance "empty" without this database first. Otherwise, it will be deleted when you restart the instance for not referenced in the new (old) file master.vmp.