Attach Database

when i attach database, an error occur:
"Error 823: I/O error (torn bage) detected during read at offset
0000000000000000 in file 'G:\bshoang\BsHoang.mdf'"
Please tell me how to resolve this problem.
Thanks!
lethuan77@.yahoo.com823 error basically tell you that BsHoang.mdf' file is corrupt beyond
repair and its the page header (offset 0000000000000000 ), so there is
no way you can attach this database, restore from a backup if you have
one.
HTH,
Dinesh

Attach Database

when i attach database, an error occur:
"Error 823: I/O error (torn bage) detected during read at offset
0000000000000000 in file 'G:\bshoang\BsHoang.mdf'"
Please tell me how to resolve this problem.
Thanks!
lethuan77@.yahoo.com823 error basically tell you that BsHoang.mdf' file is corrupt beyond
repair and its the page header (offset 0000000000000000 ), so there is
no way you can attach this database, restore from a backup if you have
one.
HTH,
Dinesh

Attach Database

when i attach database, an error occur:
"Error 823: I/O error (torn bage) detected during read at offset
0000000000000000 in file 'G:\bshoang\BsHoang.mdf'"
Please tell me how to resolve this problem.
Thanks!
lethuan77@.yahoo.com
823 error basically tell you that BsHoang.mdf' file is corrupt beyond
repair and its the page header (offset 0000000000000000 ), so there is
no way you can attach this database, restore from a backup if you have
one.
HTH,
Dinesh
sql

Attach And Detach Replication

I would like to attach and detach my database due to change the log file
since that logfile already contain too large data.
But the problem occur, It's said that must drop the replication before do
any attach on that data .But i can't drop the replication since i still need
replicate the data from the other server back to local server.
so, anyone can give me any suggestion to do the attach withour drop the
replication?
For a supported solution, you'll need to disable replication before the
detach and attach
(http://msdn2.microsoft.com/en-us/library/ms188769.aspx). Ideally script out
the publication and do a nosync initialization if you can prevent any data
access.
For an unsupported solution that doesn't involve dropping the publication,
search this newsgroup for Ponnu...
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
"sam" wrote:

> I would like to attach and detach my database due to change the log file
> since that logfile already contain too large data.
> But the problem occur, It's said that must drop the replication before do
> any attach on that data .But i can't drop the replication since i still need
> replicate the data from the other server back to local server.
> so, anyone can give me any suggestion to do the attach withour drop the
> replication?
>
sql