question

boylambing avatar image
boylambing asked

Sql 2000 backup and restore

hi,

id like to know how can i backup and restore my mdf database. \Device\Hardisk3,has a bad block where my mdf is located.

also i found this error:

Error: 823, Severity: 24, State: 2 I/O error (bad page ID) detected during read at offset 0x000000c9b1c000 in file 'D:\ms_amos_Data.MDF'.

please help!

sql-server-2000
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
RickD avatar image
RickD answered

Have you tried detaching and copying the .mdf to a new location?

Also have you tried DBCC CHECKDB()?

Do you have any existing backups? If not, why not?

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.