Re: sql dont start after detach model and msdb
From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 06/21/04
- Next message: Narayana Vyas Kondreddi: "Re: Setting 'bit' type"
- Previous message: Aaron [SQL Server MVP]: "Re: TLogs"
- In reply to: sequal: "sql dont start after detach model and msdb"
- Next in thread: sequal: "Re: sql dont start after detach model and msdb"
- Reply: sequal: "Re: sql dont start after detach model and msdb"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 21 Jun 2004 13:45:56 +0100
Hi
What does the SQL Log file say?
John
"sequal" <sequal@discussions.microsoft.com> wrote in message
news:8A3E9379-A8DA-4F70-A3A6-0835D5297B88@microsoft.com...
> hello,
>
> I am afraid, I have made a bic mistake!
>
> while trying to separate the .mdf and .ldf file on different diskdrives I
detach the model and the msdb database at the same time (with trace flag
3608 (-T3608).
> after this, I remove the traceflag and try to restart the server, but the
service wont start anymore!!!
>
> moving my user databases was quite easy, I followed the guideline in the
knowledgebase article 224071, I does also with msdb, but then I though about
safeing time and detach msdb and model in the same time.
>
> now my server wont start at all, I've tryed from enterprisemanager,
services, also with cmd: sqlservr.exe -T3608
>
> the only error I got ist 17052 "Database ID 3 doesn't found"
>
> is there anybody out with help for my?
>
> sequal (ouhh what a bad nick for such posting, shame on me)
>
- Next message: Narayana Vyas Kondreddi: "Re: Setting 'bit' type"
- Previous message: Aaron [SQL Server MVP]: "Re: TLogs"
- In reply to: sequal: "sql dont start after detach model and msdb"
- Next in thread: sequal: "Re: sql dont start after detach model and msdb"
- Reply: sequal: "Re: sql dont start after detach model and msdb"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
