Tip & How-To about Miscellaneous

How to Fix SQL Server Error 8959

Miscellaneous Logo

Related Topics:

Related Questions:

2 Answers

Creating a new database using an MDF file


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.
http://www.sqlserver.restoretools.com/
You can read up more on SQL Server here.
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/498-creating-a-new-database-using-an-mdf-file?_=1416149856104/

Nov 16, 2014 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

what is sql condition in visual basic?


sql is used for databases. Something like sql server, oracle, or access uses sql. It is a group of tables configured to reference eachother, so if you are programming in visual basic, you are trying to reference something on your sql server.

Feb 28, 2011 | Microsoft Xbox 360 Console

Not finding what you are looking for?

108 people viewed this tip

Ask a Question

Usually answered in minutes!

Top Miscellaneous Experts

Andy Fraser
Andy Fraser

Level 2 Expert

141 Answers

steve cannon

Level 1 Expert

23 Answers

William Miller
William Miller

Level 3 Expert

9085 Answers

Are you a Miscellaneous Expert? Answer questions, earn points and help others

Answer questions

Loading...