Post reply

attach and deattach database

  • April 20, 2005 at 9:53 am

    #185727

    1-After some patches were applied by Network Adminstrator, one of my database got into suspect mode. I tried to detach and re-attach the database, but I get the following error:

    " I/O error (bad page ID) detected during read at offset 0x00000000030000 in file 'E:\NLGDATA\XYZ_Data.MDF'.

    Connection Broken "

    Is there a way to get this Database up again? Unfortunately I donot have a backup as this DB

    2-is it possibel to move adata base crated with an VB application to another computer ? the application is run in some computer in a lan and gathered  data and save it in a server coputer

    the source  code is not availebel !

  • April 20, 2005 at 12:11 pm

    #553867

    If you have no backup, you're dead in the water on item 1.  On item 2, if the database has mdf and ldf files, copy them to the new computer and use sp_attach_db.

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

You must be logged in to reply to this topic. Login to reply