125
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (