Results 1 to 10 of 10

Thread: attach Help

  1. #1
    Join Date
    Jan 2004
    Posts
    4

    Unanswered: attach Help

    I received three Files .mdf .ldf .ndf and a text how to use attach
    but i always receive an error message "database is write protect ......."
    What I do wrong ?

    bye

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: attach Help

    First of all, what did you do?

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Are the three files read-only at the O/S level? This can happen if the three files were sent as attachments in e-mail.

  4. #4
    Join Date
    Sep 2003
    Posts
    522
    could it be that the database already exists and in read-only mode?

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Are we even talking about SQL Server?

    And when does the damn weekend start already......


    Code:
    DECLARE @Weekend datetime
     SELECT @Weekend = 'Jan 16 2004 17:00:00'
     SELECT DATEDIFF(mi, GetDate(), @Weekend)/60.00 As Hours_till_Margaritaville
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Jan 2004
    Posts
    4
    Sorry for mistakes
    I'll start again
    i have 3 Files xxx.mdf,xxx.ndf,xxx.ldf from originally sql7 ,from network and I'd like to atach to Sqlserver 2000; on sql server 2000 is the database not present
    With Query Analyzer I tested i did:
    Exec sp_attach_db
    @dbname="xxx",
    @filename1= "xxx.mdf",
    @filename2= "xxx.ndf",
    @filename3= "xxx.ldf"

    With Sql 2000 Manager I use The menu attach

    In both case i received this message "The Database is write Protect you
    have to unptrotect.........

    bye

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Right click on each file in succession, go to properties, and see if any of them have the read-only checkbox marked. If so, uncheck that box.

  8. #8
    Join Date
    Jan 2004
    Posts
    4
    I checked the free file , they all are not write protect

  9. #9
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    As a test, see if you can rename one of the files. Maybe backup software, or virus scan has it open?

    I just tried a test of re-attaching a readonly filegroup, and it worked. Although, I do not have access to a 7.0 machine, anymore to try out a readonly filegroup with an upgrade.

    That sparks a thought. Do you have access to the database in it's original state? That is, can you see if the original database (on SQL 7.0) is read only or had read only filegroups?

  10. #10
    Join Date
    Jan 2004
    Posts
    4
    I can rename the files, and I open the file .ndf with an Hex editor
    there are more line with read only inside the file

    bye

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •