MDF Questions

1

.mdf file backup in Visual Studio
I developed one Visual Studio .Net(C#) Project.After Publishing I couldn’t access Database(.mdf file). can yuo tell how to backup?

Answer Question   |  November 15, 2010  12:53 PM
.MDF files, Backup, C# .NET, MDF, Visual Studio
asked by:
5 pts.

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
asked by:
5 pts.

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
asked by:
30 pts.

Merging MDF files on SQL databases after restoring from a backup
I recently restored our SQL Server database from a backup, but unfortunately I used a Wednesday backup instead of Thursday, and it is now Friday. Is there a way to merge MDF files, to join all the data together because, as of now, we are missing Thursday’s data.

Answer Question   |  February 24, 2010  7:34 PM
MDF, SQL Server, SQL Server database
2,585 pts.

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
asked by:
20 pts.

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
2,585 pts.

SQL Server error: Cannot find log file
I am receiving the error, “cannot find log file.” I detach the database and I am unable to reattach it because of the error. I created a new database and copied the MDF. When I restarted the SQL Server, I am told the database is suspect. What can I do to fix this error?

Answer Question   |  July 15, 2009  2:52 PM
MDF, SQL Server database, SQL Server error messages, SQL Server errors, SQL Server logs
2,585 pts.

Where to place the tempdb log file?
I’ve heard it recommended to place the tempdb on its on own drive. Regarding the tempdb log file specifically, should it be on a different disk than the mdf or ndf files of the tempdb?

Answer Question   |  April 13, 2009  6:11 PM
MDF, NDF, SQL Server, TempDB
2,585 pts.

Merging the MDF and NDF files of SQL Server databases
How can i merge the MDF and NDF files of SQL Server databases?

Answer Question   |  March 28, 2012  6:25 PM
MDF, Merging MDF and NDF, NDF, SQL Server databases
2,585 pts.

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
2,585 pts.

Restoring a SQL database with an .mdf file
How can I restore a SQL database with an .mdf file?

Answer Question   |  May 5, 2012  3:32 PM
MDF, SQL Server database, SQL Server database restore
2,585 pts.

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
asked by:
GIG
240 pts.

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
asked by:
25 pts.

How to restore MDF file as backup database
My database saves as MDF. I want to know what are the steps to restore or create a new database using a MDF file? I tired to restore as usual but it shows an error. Please help.

Answer Question   |  April 18, 2013  10:15 AM
Backup, Database, MDF, Restore
asked by:
5 pts.

1