June 9, 2006 at 3:14 pm
I've read the stuff at http://support.microsoft.com/kb/224071/EN-US, and tried to follow it. Works great for moving everything except the model database. When trying to folow the instructions and detach it, I get this error: System databases master, model, and tempdb cannot be detached.
This is similar to the error I would expect to get for SQL 2000. So does this mean I should try to follow the SQL 2000 instructions even though I'm on SQL 7.0?
June 9, 2006 at 4:16 pm
Why do you need to move Model?
Regards,Yelena Varsha
June 9, 2006 at 4:32 pm
Customer request to move all databases off C drive to a large RAID array (E drive). I've already passed word to customer that in all likelihood this will stay where it is, since it is small, not read or written except for DB creation, and does not grow in size. I'm still curious how it is supposed to be moved.
I guess I could always try "hacking" the system tables directly, although I notice that even though I successfully moved the master, and Ent.Mgr. correctly reports the file locations on E drive from sysfiles, the sysdatabases table still lists the original C drive location for master.
June 12, 2006 at 11:37 am
Hi,
In this case I would explain to them that Model database is a System SQL Server database, not a user database. I did not have a good experience moving 7.0 system databases. If your customer insists on moving system databases you may: 1. Reinstall SQL Server (with all time billed to them) or 2. Tell them 7.0 mainstream support is not available if something happens:
http://support.microsoft.com/lifecycle/?p1=2862
| Products Released | General Availability Date | Mainstream Support Retired | Extended Support Retired | Service Pack Retired | Notes |
|---|---|---|---|---|---|
| SQL Server 7.0 Enterprise Edition | 1999-03-01T00:00:00 3/1/1999 | 2005-12-31T00:00:00 12/31/2005 | 2011-01-11T00:00:00 1/11/2011 | Not Applicable | |
| SQL Server 7.0 Standard Edition | 1999-03-01T00:00:00 3/1/1999 | 2005-12-31T00:00:00 12/31/2005 | 2011-01-11T00:00:00 1/11/2011 | Not Applicable |
For what is included in Mainstream and Extended support see here:
http://support.microsoft.com/lifecycle/?LN=en-us&x=13&y=4
Regards,Yelena Varsha
June 12, 2006 at 11:40 am
Addition to the previous post:
The header on the table is supposed to say:
Products Released General Availability Date Mainstream Support Retired Extended Support Retired Service Pack Retired Notes
For some reason I can see the header when in Edit mode but not when posted
Regards,Yelena Varsha
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply