Any database gurus out there?

stev · Postby **stev** » February 29th, 2016, 10:35 pm

having a problem on work where basically our SQL server crashed while it was in use.

I was able to pull the MDF database file off of the server but there is no hope just yet for the LDF log file.

all attempts and ratches made to re-create the log file failed. basically the SQL server was not shutdown properly and there are still 'open connections' to the database.

any ideas from the admins / IT men out there?

wagonrunner · Postby **wagonrunner** » February 29th, 2016, 11:47 pm

and no backups to another network location, or even volume shadow copy?
http://sqlmag.com/blog/recovering-database-missing-transaction-log

kurpal_v2 · Postby **kurpal_v2** » March 1st, 2016, 12:14 am

Im a self professed shakra guru.

Let me read your grah come, bring datchna 20$

stev · Postby **stev** » March 1st, 2016, 4:11 am

wagonrunner wrote:and no backups to another network location, or even volume shadow copy?
http://sqlmag.com/blog/recovering-database-missing-transaction-log

backup u say? well boy, the situation so sad that it almost funny.

bluesclues · Postby **bluesclues** » March 2nd, 2016, 9:10 pm

stev wrote:
wagonrunner wrote:and no backups to another network location, or even volume shadow copy?
http://sqlmag.com/blog/recovering-database-missing-transaction-log

backup u say? well boy, the situation so sad that it almost funny.

was going to ask you what the company backup schedule was like.. but ok

you will lose some of the data(most recent), but follow these steps and you should be able to rebuild your transaction log and get the database back online.

https://blogs.msdn.microsoft.com/glsmal ... orruption/

when you done i will let you know my consultancy fee from the overtime you going to be working lol

TheOwnerPO · Postby **TheOwnerPO** » March 2nd, 2016, 9:27 pm

ED has a degree in Computing. You can pm him.

timelapse · Postby **timelapse** » March 3rd, 2016, 7:24 am

Fix it with a hammer

IdleMind2504 · Postby **IdleMind2504** » March 3rd, 2016, 12:06 pm

check this out --> pretty good step by step post

http://yrushka.com/index.php/sql-server ... -part-3-2/

daxt0r · Postby **daxt0r** » March 3rd, 2016, 4:53 pm

stev wrote:having a problem on work where basically our SQL server crashed while it was in use.

I was able to pull the MDF database file off of the server but there is no hope just yet for the LDF log file.

all attempts and ratches made to re-create the log file failed. basically the SQL server was not shutdown properly and there are still 'open connections' to the database.

any ideas from the admins / IT men out there?

It depends on the configured recovery model set on the DB. Is it simple or full? Because only if in full does the TLOG have the roll forward data in any case.

Even if the LDF is unavailable it would still be possible to recover most of the data on the MDF assuming the problem wasn't due to disk level corruption.

Just attach the DB and do a DBCC CHECKDB after mounting to roll back any uncommitted changes.