Database

EricDV wrote:

Actually, it is an .mdf file

EricDV wrote:

You can use sp_attach_db, sp_attach_single_file_db

Remarks<br />
sp_attach_db should only be executed on databases that were previously detached from the database server using an explicit sp_detach_db operation.

<br />
Attempt 1 (Strike 1): TRIED TO EXECUTE IN QUERY ANALYZER<br />
EXEC sp_attach_db @dbname = 'NewDatabase', <br />
 @filename1 = 'c:\mssql7\data\ArchiveData.mdf', <br />
 @filename2 = 'c:\mssql7\data\ArchiveLog.ldf'<br />
 <br />
SERVER MESSAGES:<br />
Server: Msg 9004, Level 21, State 3, Line 1<br />
The log for database 'NewDatabase' is corrupt.<br />
Connection Broken<br />
 <br />
(Continued) ISSUE:<br />
The log file is corrupt, so I tried to attach the mdf file to a new database using the single file attach method.<br />
 <br />
Attempt 2 (Strike 2):TRIED TO EXECUTE IN QUERY ANALYZER<br />
EXEC sp_attach_single_file_db @dbname = 'NewDatabase', <br />
 @physname = 'c:\mssql7\data\ArchiveData.mdf'<br />
 <br />
SERVER MESSAGES:<br />
Server: Msg 945, Level 14, State 2, Line 1<br />
Database 'NewDatabase' cannot be opened because some of the files could not be activated.<br />
Server: Msg 1813, Level 16, State 2, Line 1<br />
Could not open new database 'NewDatabase'. CREATE DATABASE is aborted.<br />
 <br />
Attempt 3 (Strike 3 --- Struck OUT): tried to fool SQL Server by switch mdf files. <br />
I created a brand new database called Archive.<br />
I detached the database.<br />
I renamed the Archive_Data.mdf to Archive_DataOld.mdf<br />
I applied the switch by renaming the AchiveData.mdf  to Archive_Data.mdf <br />
I left the brand new log file alone.<br />
I attempted to attach the database<br />
 <br />
EXEC sp_attach_db @dbname = 'Archive', <br />
 @filename1 = 'c:\mssql7\data\Archive_Data.mdf', <br />
 @filename2 = 'c:\mssql7\data\Archive_Log.ldf'<br />
 <br />
 <br />
also tried<br />
 <br />
EXEC sp_attach_db @dbname = 'NewDatabase', <br />
 @filename1 = 'c:\mssql7\data\Archive_Data.mdf', <br />
 @filename2 = 'c:\mssql7\data\Archive_Log.ldf'<br />
 <br />
SERVER MESSAGES:<br />
Changed language setting to us_english.<br />
Server: Msg 5173, Level 16, State 2, Line 1<br />
Cannot associate files with different databases.<br />

if(Page.IsPostBack)
{
BindData();
}

private void BindData()<br />
		{<br />
			strPartNumberInputReference = txtPartNumberInput.Text;<br />
			<br />
<br />
			string SQLString = "SELECT p.PartNumber, pt.description, dd.DrawingNumber, dd.DrawingRevision, dd.DwgPath FROM parts p INNER JOIN PartTypes pt on pt.ID =p.PartTypeID LEFT JOIN DraftingData dd on dd.PartID = p.ID WHERE p.PartNumber = @PartID;SELECT w.weight, wt.Description AS wtDescription, p.PartNumber from weights w INNER JOIN weighttypes wt on wt.ID = w.weighttypeid INNER JOIN Parts p on w.PartID = p.ID WHERE p.PartNumber = @PartID;SELECT c.cost, p.PartNumber, ct.Description AS ctDescription from Costs c INNER JOIN Parts p ON c.PartID = p.Id INNER JOIN CostTypes ct on ct.Id = c.CostTypeID WHERE p.PartNumber = @PartID; SELECT s.SubPartID, s.Quantity, s.Sequence, p.PartNumber FROM SubParts s INNER JOIN Parts p ON s.PartID = p.Id "; <br />
			<br />
			<br />
			SqlCommand cmd = new SqlCommand();<br />
			cmd.Connection = new SqlConnection(strConnectSQL);<br />
			cmd.CommandText = SQLString;<br />
			cmd.Parameters.Add ("@PartID", strPartNumberInputReference);<br />
			SqlDataAdapter adapter = new SqlDataAdapter(cmd);<br />
			adapter.Fill(ds);<br />
<br />
		<br />
			ds.Tables[1].TableName = "Weights";<br />
			ds.Tables[2].TableName = "Costs";<br />
			ds.Tables[3].TableName = "Subparts";<br />
		<br />
			dgParts.DataSource = ds;<br />
			dgParts.DataBind();<br />
			txtPartNumberInput.Text = "";<br />
		}

public void dgParts_edit (object sender, DataGridCommandEventArgs e)<br />
		{<br />
			dgParts.EditItemIndex = e.Item.ItemIndex;<br />
			BindData();<br />
		}

SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'NameOfTheTableHere'