Tip & How-To about Microsoft SQL Server 2008 Enterprise Full Version for PC (1 Server/s, 1 Processor/s) (810-07364)

Shrink SQL Server Transaction Log File

Microsoft SQL Server 2008 Enterprise Full Version for PC (1 Server/s, 1 Processor/s) (810-07364) Logo

Related Topics:

Related Questions:

2 Answers

Attach a database without the corrupted log file


There might be other options out there. This is something that worked for me once but there are no guarantees that it will work at all times.

Stop SQL Server instance -> Copy MDF and LDF files to another location -> Delete original MDF and LDF files -> Start SQL Server instance again -> Create new database with exact same name and file names -> Stop SQL Server -> overwrite newly created MDF and LDF.

After this your database should be back online. If it is then go ahead and put it into EMERGANCY mode and SINGLE USER mode.

Finally go ahead and execute DBCC CHECKDB like this

DBCC CHECKDB (databaseName, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS

More information you can dig out from resources directly connected with SQL Server databases and database corruption in MS SQL Server any version...
http://itknowledgeexchange.techtarget.com/itanswers/how-to-restore-mdf-file-as-bakcup-databe/
https://www.repairtoolbox.com/sqlserverrepair.html SQL Server Repair Toolbox

May 15, 2015 | Microsoft SQL Server 2008 Enterprise Full...

5 Answers

Is it good idea to repair sql file?


Bulk Logged will not help you in this situation. Your transaction log is growing because you are performing large transactions. In simple mode, the log is truncated after a checkpoint.
Check these site: http://www.sql.recoverytoolbox.com/ & download demo Recovery Toolbox for SQL Server.
Depending on how you are loading your data, you may need to break it up into smaller chunks. Make sure you are not loading all the data in one large transaction.
Read more: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/380-is-it-good-idea-to-change-simple-recover-model-into-bulk-logged-on-etl-system

Nov 06, 2014 | Microsoft SQL Server 2005 Standard Edition

4 Answers

whst is the difference between .mdf,.ldf & .sdf?


LDF - layered data file, is the transaction log file for your database. It allows you to roll back changes you made to the data to a particular point and is used in rebuilding the data should it become corrupted.

MDF - Meta data file, is your actual data

SDF - Is a sequential data file, a flat file that can be used for compatibility with MS-SQL server, MySQL, etc.

Dec 03, 2009 | Oracle 10g Database Standard (ODBSEONUPP0)

Not finding what you are looking for?

635 people viewed this tip

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2936 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18414 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Loading...