SQL 2008 R2 - MASTER.LDF corrupted without backup
Posted 26 April 2015 - 01:53 PM
Posted 26 April 2015 - 02:32 PM
Hey there basheer and welcome to GeeksToGo... I have experienced this problem before and used the code you see below:
USE [master] GO CREATE DATABASE [NewDatabaseName] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\OldDatabaseName.mdf' ) FOR ATTACH GO
This will create a new transaction file and allow access to your database again. As you can see I have just used general place holders (NewDatabaseName and OldDatabaseName) you will have to replace these with the relevant names.
Please let me know how thing go and if there anything else you might require.
Posted 27 April 2015 - 05:27 AM
Try this one solution...
1. First Shutdown SQL Server
2. Then move the current database file/rename (do not touch the .ldf)
3. After rename/move db, restart SQL Server
4. Create a new database with same name and log file and location also same
5. Stop SQL Server
Make use of some interesting links which might help you....
http://www.filerepai...08-is-corrupted- a lot of guides and tips for corrupted sql server databases
https://repairsql.recoverytoolbox.com/Recovery Toolbox for SQL Server - free demo version of this tool, if any variant doesn’t seem effective
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users