Database is not starting up
From: Vinod Meesala (meesala_at_hotmail.com)
Date: 10/08/04
- Next message: Jaxon: "Re: Network Applicance V's EMC"
- Previous message: Bhanu: "Re: making columns unique"
- Next in thread: Sue Hoegemeier: "Re: Database is not starting up"
- Reply: Sue Hoegemeier: "Re: Database is not starting up"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 8 Oct 2004 13:42:18 -0700
Hi,
I was trying to move the MSDB and Model datafiles from one
location to another. I was using following process
described by Microsoft:
To move the MSDB database on SQL Server 2000, follow these
steps:
In SQL Server Enterprise Manager, right-click the server
name and click Properties.
On the General tab, click Startup Parameters.
Add a new parameter as "-T3608" (without the quotation
marks).
After you add trace flag 3608, follow these steps:
1. Stop, and then restart SQL Server.
2. Make sure that the SQL Server Agent service is not
currently running.
3. Detach the msdb database as follows:use master
go
sp_detach_db 'msdb'
go
4. Move the Msdbdata.mdf and Msdblog.ldf files from the
current location (D:\Mssql8\Data) to the new location
(E:\Mssql8\Data).
5. Remove the -T3608 trace flag from the startup
parameters box in Enterprise Manager.
6. Stop and then restart SQL Server.
7. Reattach the msdb database as follows: use master
go
sp_attach_db 'msdb','E:\Mssql8
\Data\msdbdata.mdf','E:\Mssql8\Data\msdblog.ldf'
go
Of the above steps I had the problem in 6th step.. i.e.,
After detaching the databases and moving MSDB and Model
database files I stoped the server and trying to restart.
But it is not restarting. When I checked in error log
file I see the following:
2004-10-08 15:14:56.84 spid5 Could not find database
ID 3. Database may not be activated yet or may be in
transition.
Anyone know what happened here and what should be done now?
Thanks in advance,
Vinod
- Next message: Jaxon: "Re: Network Applicance V's EMC"
- Previous message: Bhanu: "Re: making columns unique"
- Next in thread: Sue Hoegemeier: "Re: Database is not starting up"
- Reply: Sue Hoegemeier: "Re: Database is not starting up"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
