Question about Microsoft SQL Server 2000 Standard Edition for PC
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 tried to restore as usual but it shows an error. Please help.
An MDF file isn't a backup file isn't the main data file (or master data file depending on who you ask) hence the file extension MDF. You can attach the MDF to the database by right clicking on the databases folder in Enterprise Manager (SQL 2000) or Management Studio (SQL 2005) then selecting all tasks and then Attach Database.
When you do this you will get an error about the log file missing. This shouldn't matter as SQL Server will simply create a new log file for you.
This will only work if the SQL Server was stopped when you copied the MDF file from the old SQL Server. If you copied the file while the SQL Server was running this file probably will not attach either and you will need to get a valid backup of the database.
Download help tool for sql database - SQL Server Restore Toolbox.
You can read up more on SQL Server here.
Posted on Nov 19, 2014
CREATE DATABASE Database1 ON
(FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQLSERVER12.MSSQLSERVER\MSSQL\DATA\testdb.mdf ')
Posted on May 23, 2016
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jan 19, 2016 | Microsoft SQL Server 2008 Enterprise Full...
May 15, 2015 | Microsoft SQL Server 2008 Enterprise Full...
Apr 25, 2015 | Microsoft SQL Server 2005 Enterprise...
May 12, 2014 | Microsoft Database Software A5K-02817 SQL...
Apr 17, 2014 | Computers & Internet
Jun 22, 2010 | Microsoft SQL Server 2005 Enterprise...
Sep 10, 2009 | Microsoft Computers & Internet
Feb 11, 2008 | Microsoft SQL Server 2000 Standard Edition...
Jul 24, 2012 | Microsoft SQL Server 2000 Standard Edition...
284 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: