<div>
did you backup the database before you detached it?
</div>


did you backup the database before you detached it?

<div>
Have you tried sp_attach_single_file_db
</div>


<div>
Create Database AdventureWorks<br />
(Name=Adventureworks, file='C:\Program Files\Microsoft SQL Server\MSSQL.1\Data\Advent<wbr />ureWorks_L<wbr />og.ndf<br />
FOR ATTACH_REBUILD_LOG<br />
is another one we are going over.<br />
thank you ptjcb.<br />
~W. 
</div>


Create Database AdventureWorks
(Name=Adventureworks, file='C:\Program Files\Microsoft SQL Server\MSSQL.1\Data\AdventureWorks_Log.ndf
FOR ATTACH_REBUILD_LOG
is another one we are going over.
thank you ptjcb.
~W.

<div>
<div class="content wysiwyg-content">
Question: if you detached your database, stopped your SQL service, and deleted the transaction log file in SQL 2005, how would you be able to recover - or even bring the database back online?<br />

</div>
</div>


Question: if you detached your database, stopped your SQL service, and deleted the transaction log file in SQL 2005, how would you be able to recover - or even bring the database back online?


How would you bring back a SQL2005 database if the transaction log was deleted?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.