MDF

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?

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?

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?

Merging the MDF and NDF files of SQL Server databases

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

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?

Restoring a SQL database with an .mdf file

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

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

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 read at...

How to restore mdf file as backup database

I have my database saves as mdf , i want what is the steps to restore or create a new database using this mdf file. I tired to restore as usual, it shows error? Please help