... or recover data from a corrupt (LDF) log file. I have a situation ... data from the damaged (mdf) data file however not all of the information was recovered. The (ldf) log file is twice the size of the (mdf) file and I believe the missing data ...was not committed to the mdf file before the hardware failure. Unfortunately there...or retrieve any information from that LDFfile. If anyone knows of or...
...in this scenario if your database corrupts (because of a power cut ... should explicitly take your log file's backup. -- Ekrem Önsoy "Joe ... 11D to back up my SQL DB's and I use ... running the shrink on the .ldf DB's in full mode?... a similar issue with both SQL2000 and 2005, where if ... recovery for good. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se ...
... your original .mdf & .ldffiles, so that if they get corrupted by different attempts you still have ...an MSDE database would work in SQL Express without any changes. Stranger things...the data through access (or SQL Server 2000/2005 if that is available...I can however access the data files on the hard drive. I now...read/access my BCM 2003 data file. Is there anything else I can...
... or methods to recover a corrupted mdf file (SQL -MSDE 2000)..please help me and ... been marked SUSPECT by recovery. See the SQL Server errorlog for more information. ... i....MDF', @filename2 = N'C:\Program Files\Microsoft SQL Server\MSSQL$RUBYMSDEINSTANCE\Data\RubyDB_Log.LDF' ; An got a message : Msg 9003, ... analyze the database problem (in the .mdf file) and a way to get back the...
... or methods to recover a corrupted mdf file (SQL -MSDE 2000)..please help me and ... been marked SUSPECT by recovery. See the SQL Server errorlog for more information. ... i....MDF', @filename2 = N'C:\Program Files\Microsoft SQL Server\MSSQL$RUBYMSDEINSTANCE\Data\RubyDB_Log.LDF' ; An got a message : Msg 9003, ... analyze the database problem (in the .mdf file) and a way to get back the...
... seems that we are using SQL2000 at work and the ... Management Server installed along with 2000 Enterprise Manager. Maybe AdventureWorks just ... 602 can certainly indicate database corruption, but it is also returned...chosen, both the mdf and ldffiles appear below in thebox...CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602) "Jay B...
...-install all previous SQL2000 database files. The file names and ... copy of the Adventureworks files are corrupt? -- Arnie Rowland, Ph.D...chosen, both the mdf and ldffiles appear below in thebox...database, the mdf and the ldf. they act as a set...CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602) "Jay B...
...tried using Enterprise Manager for SQL2000. I don't know...copy of the Adventureworks files are corrupt? -- Arnie Rowland, Ph.D...chosen, both the mdf and ldffiles appear below in thebox...CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602) "Jay B...but when I bring up SQL Server Management Studio, I don...
...I tried using Enterprise Manager for SQL2000. I don't know what...your copy of the Adventureworks files are corrupt? -- Arnie Rowland, Ph.D.... chosen, both the mdf and ldffiles appear below in thebox.... CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602) "Jay B" ... and downloaded the AdventureWorks.msi file. When it ran, it says ...
... tried using Enterprise Manager for SQL2000. I don't know...copy of the Adventureworks files are corrupt? -- Arnie Rowland, Ph.D...chosen, both the mdf and ldffiles appear below in thebox...CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602) "Jay B...and downloaded the AdventureWorks.msi file. When it ran, it says...
