
Hi; Need Help.-
One computer broke, all thought the hard drive is OK. I need to copy the database files to another computer, I install the HD as slave drive at another computer and I can see everything. BUT which files do I need to copy and what other steps do I need to do. I can not use HQ administrator to do a backup.
I really apreciate any help
*This post is locked for comments
I have the same question (0)C:\Program Files\Microsoft SQL Server\xxx (version number of SQL)\MSSQL\Data\ the .mdf and .ldf files
Then install HQ/SO on the new machine/drive. Create a new database using the same name as before. Stop the SQL Service in Control Panel | Administrative Tools | Services | find SQL Server, right click on it and stop it. Now copy over your old files in to the same location as the files you just created (same path as above), saying yes to overwrite them. Lastly re-start the SQL Server.
Open SO/HQ Admin and log into the database. Now under the Database Menu, do a re-index and then a check