Question about Microsoft SQL Server 2008 Enterprise Full Version for PC (1 Server/s, 1 Processor/s) (810-07364)
I have a SQL server that has a corrupt MASTER.LDF file, which prevents SQL services from starting at all. Is there any way to start SQL services with just MASTER.MDF? So far I have tried renaming MASTER.LDF to MASTER.LDF.OLD and SQL reports that the file is missing and still does not start although I do not get a corrupt message. If I cannot start MASTER.MDF without the log file, is there a way to rebuild the log file? Help is appreciated. Thanks!
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.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/1465-table-in-sql-server-2008-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
Posted on Apr 27, 2015
Take a look at this article it will help you to rebuild the master database file: https://blogs.technet.microsoft.com/fort_sql/2011/02/01/the-easiest-way-to-rebuild-the-master-database/
Posted on Jun 07, 2016
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jan 19, 2016 | Microsoft SQL Server 2008 Enterprise Full...
May 15, 2015 | Microsoft SQL Server 2008 Enterprise Full...
Jun 10, 2014 | Microsoft Database Software A5K-02817 SQL...
May 12, 2014 | Microsoft Database Software A5K-02817 SQL...
Apr 17, 2014 | Computers & Internet
Dec 03, 2009 | Oracle 10g Database Standard (ODBSEONUPP0)
Sep 19, 2016 | Microsoft SQL Server 2008 Enterprise Full...
Mar 21, 2017 | Microsoft SQL Server 2008 Enterprise Full...
226 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: