Hi,
I detached a database from Server1 and took MDF file to Server2.
After that I re-attached the database on Server1.
When I tried to attached database using EM, sp_attach_db and also
sp_Attach_single_file, i was getting error msg 1813.
So I detached database again from Server1 and used the LDF on Server2.
It recognizes and LDF file and attaches the database. However, the
database is in read-only mode. I can go to properties and uncheck
"Read-Only" but when I try to save the changes it gives me Error 5105
- Deactivation Error...
I don't have access to new MDF file after I detached it again.
Any help will be greatly appreciated.
DivyeshCheck the file properties for the mdf and ldf at the
operating system level and make sure the files themselves
are not set to read only for the file properties.
-Sue
On 1 Dec 2004 13:53:26 -0800, divyeshkhatri@.hotmail.com
(Divyesh) wrote:
>Hi,
>I detached a database from Server1 and took MDF file to Server2.
>After that I re-attached the database on Server1.
>When I tried to attached database using EM, sp_attach_db and also
>sp_Attach_single_file, i was getting error msg 1813.
>So I detached database again from Server1 and used the LDF on Server2.
> It recognizes and LDF file and attaches the database. However, the
>database is in read-only mode. I can go to properties and uncheck
>"Read-Only" but when I try to save the changes it gives me Error 5105
>- Deactivation Error...
>I don't have access to new MDF file after I detached it again.
>Any help will be greatly appreciated.
>Divyesh
No comments:
Post a Comment