Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Deleted Transaction Log

    DavidB,

    I only have one log file -- the one that I deleted.

    --David

  • RE: Deleted Transaction Log

    I copied the MDF file to my notebook and tried to attach the database to local SQL Server and received the following error:

    Error 823: I/O error (torn page) detected during...

  • RE: Deleted Transaction Log

    DavidB,

    I tried:

    CREATE DATABASE Billing

    ON PRIMARY (FILENAME = 'F:\SQL Server Data\Billing_Data.MDF')

    FOR ATTACH

    GO

    AND received the following error message:

    Server: Msg 1813, Level 16, State 2, Line 1

    Could not open new database 'Billing'....

  • RE: Deleted Transaction Log

    DavidB,

    I executed the following command as you suggested:

    EXEC sp_attach_single_file_db @dbname = 'Billing',

    @physname = 'F:\SQL Server Data\Billing_Data.MDF'

    AND received the following error message:

    Server: Msg 1813, Level 16, State 2, Line 1

    Could...

Viewing 4 posts - 1 through 4 (of 4 total)