October 8, 2002 at 6:55 pm
I have a read-only(database read-only, not file properties) mdf file created from Sql Server 7.
I'm trying to migrate this datafile into a Sql Server 2000 environment, but am having troubles.
Without having access to Sql Server 7 right now, how can I attach this file? I cannot make it 'writable'. I only need to extract the information, not modify it.
I get the following error:
Server: Msg 3415, Level 16, State 2, Line 1
Database 'MyDb' is read-only or has read-only files and must be made writable before it can be upgraded.
Thanks!
Shawn
October 8, 2002 at 7:09 pm
You do have to make writeable as the DB must be upgraded to SQL 2000 to attach, which means changes will take place. Now if you do not have access to SQL 7, if you have a box you can install on you can even use the 120 Day eval of SQL 7 to do just long enough to make writeable, or if find someone you trust who can do it for you.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 8, 2002 at 10:33 pm
Unfortunately I'm going to be receiving these sql server 7 mdf datafiles on a monthly basis from a vendor-the 120 day license would only be a temporary bandaid. I was hoping there was something in the "sp_attach/create database attach" syntax I overlooked that would allow the conversion. There is not a stand alone utility that would do something like this is there?
Or can MSDE1.0 and SqlServer 2000 co-exist on the same box?
Thanks!
Shawn
October 9, 2002 at 4:18 am
I know of no method that will attach as marked read. I am not sure on the MSDE 1 and 2000 thing and would probably do on another machine istead of on the same. If you are going to get these monthly why not just ask the vendor to send as not mark readonly so you don't have to worry about this?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply