locked
How Can I attached database RRS feed

  • Question

  • when I am Going to attaching the database I am geting the below error. I can't Underestand what is the probleme

    Regards

    Suman

    An error occurred when Attaching the database. Click The hyperlink in the Massage coloum for Deatails. 

    Tuesday, October 12, 2010 7:06 AM

All replies

  • You would get a hyperlink on the same screen. What does hyper link message say?


    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Tuesday, October 12, 2010 7:29 AM
  • Can you give the full details of the error message + version of SQL you are using?

    Tom


    Tom Van Zele | Blog | Twitter | LinkedIn
    Tuesday, October 12, 2010 7:29 AM

  • Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Tuesday, October 12, 2010 8:05 AM
  •  

    I am gating this error Below. I am using sqlserver 2005 Enterprise Edition 

     

                    Attach Database Faild for Server FBC|Sqlexpress

                    Additional Information:

    (An execption occurred while executing a transact-SQL statement or batch. )

    (Microsoft.Sqlserver.ConnectionInfo)

    Database FBC_ERP cannot be upgraded because it is read-only or has read-Onlyflies. Make the database or files Writeable, and return recovery.

     

    Could not open new database FBC_ERP. Create database is aborted. (Microsoft Sql server, Error: 3415) 

     

     

    Tuesday, October 12, 2010 9:01 AM
  • Are you trying to attach a database originally from SQL 2000? If so: please check http://support.microsoft.com/kb/931640

    Tom


    Tom Van Zele | Blog | Twitter | LinkedIn
    Tuesday, October 12, 2010 9:05 AM
  • I was able to Repro by
    1. Create database on SQL 2008
    2. Detached database
    3. Made files as "Read-Only" by going to file, properties from OS
    4. Tried attaching database to SQL 2008 R2 and got same error

    So, please make sure database files are not readonly.

    Also check Tom's post.


    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Tuesday, October 12, 2010 9:11 AM