SQL Recovery from MDF and LDF – Missing Data
Where to start … On 6/2 we lost a major system that we found relies on a database that hasn’t been backed up since 5/7. We lost 3 of 4 HDD in a RAID5 array. We sent the drives to a recovery firm and they have recovered all of the data. However, the timestamp on [...]

Answer Question   |  October 5, 2011  2:10 PM
LDF, MDF, SQL 2000, SQL Server 2000, SQL Server backup, SQL Server backup and restore

attach a new mdf and ldf files in sql server 2005 enterprise
i have a new mdf and ldf file created in sql server 2000.how could i attach these to sql server 2005 enterprise edition?i tried it by right click the database and select attach.but it shows an error when click the add button in database dialogue box.

Answer Question   |  March 26, 2010  6:45 PM
LDF, MDF, SQL Server 2000, SQL Server 2005, SQL Server 2005 Enterprise Edition

How to restore Sql Server 2000 mdf and ldf data
I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2000

Answer Question   |  December 3, 2009  2:54 PM
.MDF files, LDF, MDF, SQL Restore, SQL Server 2000

Recovering lost SQL Server 2000 data
I lost a LDF file for SQL server 2000 — but I have the MDF. How can I recover my data?

Answer Question   |  December 13, 2010  6:47 PM
Data Recovery, LDF, MDF, SQL Server 2000, SQL Server backup and restore

How can I reduce the size of an LDF file?
How can I reduce the size of an LDF file?

Answer Question   |  May 2, 2009  7:19 PM
LDF, LDF size reduction., SQL Server

Attaching MDF and LDF files to SQL Server 2005
I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2005?

Answer Question   |  May 20, 2011  3:33 PM
LDF, MDF, SQL Server 2005

A job to move database files from one server to different server
Hi I have job which creates databases based on month in analysis services which contains cubes in the databases. I need to create a job to move the database ldf and mdf files of the previous months removing the database from the server if the month changes to next month. The database files should be [...]

Answer Question   |  October 14, 2008  5:15 PM
Database, LDF, MDF, SQL Server

LDF size reduction
How can reduce *.LDF size i have run the command dbcc shrinkfile (Filename,1) but could not reduced.

Answer Question   |  August 21, 2008  2:11 PM
LDF, SHRINKFILE

SQL Server Error while creating db from DUMP
Hi, We get the following error while trying to create a new db from a dump which contains the MDF and LDF files. Appreciate if anyone could let me know on what could be the reason for this error. The operating system returned error 38(Reached the end of the file.) to SQL Server during a [...]

Answer Question   |  September 9, 2008  2:55 PM
LDF, MDF, SQL Server database, SQL Server errors