Yesterday I copied sql database from pc to flash card. Today I opened database and saw a message: SQL Server Table Corruption Error. I opened a copy from flash card and the same error. How to make sql database repair?
Ok, I’ll try to help you somehow. These options often help me. If you need to manually restore an SQL Database in Management Studio you can follow the instructions below for the version of SQL Server running on your server.
SQL 2012:
- Log onto SQL Server Management Studio.
- Navigate to the database you wish to restore.
- Right Click > Tasks > Restore > Database.
- Once on the General tab set the source to Device > Select Backup Device > Add > Navigate to the .bak file you’re restoring to.
- Ensure the Destination Database is the correct one.
- Select the Options tab.
- Check “Overwrite the existing database (WITH REPLACE)” and “Close existing connections to destination database”.
- Uncheck “Take tail-log backup before restore”.
- Click OK.
Thanks for advice, great solution.
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.