Creating a new database using an MDF file
Closed
samuelconaghan
Posts
1
Registration date
Sunday November 16, 2014
Status
Member
Last seen
November 16, 2014
-
Nov 16, 2014 at 05:26 AM
jackoboyle51 Posts 1 Registration date Wednesday November 19, 2014 Status Member Last seen November 19, 2014 - Nov 19, 2014 at 01:05 PM
jackoboyle51 Posts 1 Registration date Wednesday November 19, 2014 Status Member Last seen November 19, 2014 - Nov 19, 2014 at 01:05 PM
Related:
- Creating a new database using an MDF file
- Ms access database free download - Download - Databases
- Windows 10 iso file download 64-bit - Download - Windows
- Dvi file - Guide
- Create rar file mac - Guide
- Safari cannot open the page because it is a local file - Guide
1 response
jackoboyle51
Posts
1
Registration date
Wednesday November 19, 2014
Status
Member
Last seen
November 19, 2014
Nov 19, 2014 at 01:05 PM
Nov 19, 2014 at 01:05 PM
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.
https://sql.recoverytoolbox.com/
You can read up more on SQL Server here.
http://ww7.filerepairforum.com
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.
https://sql.recoverytoolbox.com/
You can read up more on SQL Server here.
http://ww7.filerepairforum.com
