Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-03 : 08:12:55
|
| Prem writes "Sir, Sqlserver service starts and stops immediately. I found the following errors in event viewer. Event-id 17055. Device activation error. The physical file name 'E:\mssql\data\modellog.ldf may be incorrect'I had sql 7 with Sp4 on win2k. Now decided to change to sql2000 with sp3 on Win2003. When I tried to restore the system databases on sql2k on win2003 instant it gave 'Version error'.There are about 15 Databases with 25 GB. So to save time on restoring all databases, I upgraded existing SQL7 to SQL2K with SP3. Took back-up of system databases and restored on the second Fresh instant of SQL2000 with SP3 on Win2003 (both are on the same Server). The Master DB got restored but unable to restore the model and MSDB. It gave error sharing violation. But when the master got restored it showed all the databases of the previous instant in the new instant since the physical files path were not altered. And also the applications started working. The only problem was the path of Model and MSDB files was showing the old instant's path., not the new instant's installation path. How can I restore the model and MSDB database without re-installation SQL2K. Now even the old instant SQL Server service is not starting with the above error. I hv the backup of the system databases of old instant, but do not have physical file copies. (This is a test server and I need to do this exercise on the live server in near future with out much down time). Any other easy way of doing it..ThanksPrem" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-03 : 13:08:37
|
| You mentioned install service pack 3 for SQL Server 2000. In order to run SQL Server 2000 on Windows 2003, you need to install service pack 3a for SQL Server 2000.Tara |
 |
|
|
MuadDBA
628 Posts |
Posted - 2004-06-03 : 14:35:13
|
| You can't restore SQL 7 system DBs to a SQL 2000 system. Or at least, it isn't recommended in any of the literature I have read. |
|
|
|
premdn
Starting Member
1 Post |
Posted - 2004-06-05 : 07:48:27
|
| Yes. I installed SP3 for SQL2k. As mentioned earlier I have 2 instancs. First SQL7 on Win2K and Second SQL2K on Win2003. The First instant of SQL7, I upgraded to SQL 2K and then the system dbs I restored on to the Second Instant (win2003 and SQL2K). But when I restored the Master DB on Second Instant it showed all the user databases (because in both the cases the databases paths where same). How do I restore the MSDB and Model DBs. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-07 : 12:27:49
|
| You don't restore those system databases during the upgrade process. You transfer the objects that you need to the new instance.Tara |
|
|
|
|
|
|
SQL Server Service not Starting.