Jump to content

.mdf file


lucalewis

Recommended Posts

Good afternoon.

 

So there SCCM2012r2 mode primary site (PS), is 5t secondary site (SS).

 

It so happened that the file is broken: master.mdf or mastlog on primary site, do not start sql-server, and SQL + SCCM one a server, there is no fresh backups, the last master.mdf (mastlog.ldf), 5-month-old, Compare 55-bit differences found with a broken. In an isolated network start his sccm2012r2 (primary site) to those files - start. After starting the differences between the broken files to and from backup (but where was the launch) - it was 48.

 

Thanks in advance.

Link to comment
Share on other sites

Couple things you may use, restore sql table via instruction with some steps, or if you can't overcome issue by manually guides make use of https://sql.recoverytoolbox.com/ Recovery Toolbox for SQL Server

 

1. Insert the SQL Server Installation disc into the server computer's disc drive. Access the drive from your computer by clicking "My Computer" from the desktop and double-clicking the disc drive icon.

2. Run setup.exe from the SQL server installation disc. The setup command should be located in the disc's root directory. Run the setup program by double-clicking "setup.exe." This will bring up the SQL server installation center page.

3. Click the "Maintenance" button located on the lefthand side of the navigation window. Select "Repair" and then choose the language you wish the program to be presented in after installation. Click "Next" to continue. This will run setup routines, making sure your computer has all the prerequisites installed to correctly run SQL server 2008. Click "OK" or "Install" to continue. This will bring you to the Select Instance page.

4. Select the instance you want to repair. This will reconfigure your server using automatic backups to a time the server was working correctly and reinstall any corrupted information. Click "Next." The repair rules will automatically verify the operation. Click "Next" to continue. This will take you to the Ready to Repair page.

5. Click "Repair" and SQL server disc will run its repair function. The repair progress bar will show the completion level of the repair. Once the repair function is complete, click "Finish" to exit the repair program. Reboot the server machine to complete the repair.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...