var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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 ?
Re: attach Help
First of all, what did you do?
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.
could it be that the database already exists and in read-only mode?
Are we even talking about SQL Server?
And when does the damn weekend start already......
DECLARE @Weekend datetime
SELECT @Weekend = 'Jan 16 2004 17:00:00'
SELECT DATEDIFF(mi, GetDate(), @Weekend)/60.00 As Hours_till_Margaritaville
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:
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.........
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.
I checked the free file , they all are not write protect
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?
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