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
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
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
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
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
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
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
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
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
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
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
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
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
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