Cannot recover the master database.

Hi,
In my computer when sql is starting occur the follow
message in log :
- Error: 9003, Severity: 20, State: 1.
- Cannot recover the master database.
What I do? Why this happened?
Thanks,
Daniela"Daniela" <daniela@.perfilcs.com.br> wrote in message
news:257101c41b18$e6f5f3e0$3a01280a@.phx.gbl...
> Hi,
> In my computer when sql is starting occur the follow
> message in log :
> - Error: 9003, Severity: 20, State: 1.
> - Cannot recover the master database.
> What I do? Why this happened?
>
To fix a corrupted master database run rebuildm.exe. This will destroy your
master, msdb and modle databases and replace them with blank ones. Then
restore your master, msdb and model backups.
Erm... You do have a backup of your system databases, don't you?
If not, then after rebuildm.exe you'll have to execute sp_attach_db or
sp_attach_single_file_db to repopulate your sysdatabases table in Master.
Also you will have to recreate your SQLAgent jobs etc if you do not have a
MSDB backup
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.647 / Virus Database: 414 - Release Date: 29/03/2004|||i hope you been backing up your system database regularly. if you don't. you
are in trouble.
you can't restore a corrupt master.mdb thru GUI.
-- to exclusive use the master database (to restore)
/* start the server in exclusive mode
From a command prompt (the dos prompt, get to the c:\mssql7\binn directory
(adjust accordingly for sql2k), enter:
sqlservr.exe -c (standard)
sqlservr -m (exclusive)
restore master db from the last known good backup
stop server and re-start in normal mode
*/
once the master is restored. you can use Enterprise Manger GUI to restore
the last known good copy of msdb.
Steve Lin
MCDBA
"Daniela" <daniela@.perfilcs.com.br> wrote in message
news:257101c41b18$e6f5f3e0$3a01280a@.phx.gbl...
> Hi,
> In my computer when sql is starting occur the follow
> message in log :
> - Error: 9003, Severity: 20, State: 1.
> - Cannot recover the master database.
> What I do? Why this happened?
> Thanks,
> Daniela
>

Cannot Generate SSPI Context

Hi,
I have upgrade my windows 2000 to service pack 4
and when i leave the sql server idle for around 2 hours,
an error occur -- Cannot Generate SSPI Context.
Why this problem still occur since i have upgrade
to service pack 4. Is it i am wrong in the step while
trying to connect to the sql server or is it related to
the network logon window authentication problem?
Thank u very much.
regards,
florenceCheck out this article:
http://support.microsoft.com/?id=811889
HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message
Rand
This posting is provided "as is" with no warranties and confers no rights.

Cannot Forward Scheduled PDF Attachments from Outlook Web Access

I cannot forward pdf attachments that were created via daily scheduling
within outlook web access. This does not seem to occur with manually
attached pdfs that were created via Reporting Services or from within regular
outlook. This leads me to believe there is something funky with the WAY the
attachment is done in daily schedules. Please Advise.
Thanks,
Scott EguiresDidn´t had that problem, even I did that sometime on my own, perhaps if
nobody knows something about it you could keep in touch with that guy from
the post to see wheter he solved the problem in some way:
http://groups.google.de/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/15ca7440b6815a48/ef9c4b2c34e979cd?q=forward+attachments&rnum=2&hl=de#ef9c4b2c34e979cd
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Scott Eguires" <ScottEguires@.discussions.microsoft.com> schrieb im
Newsbeitrag news:7D9D869A-1F6B-4D41-8CB9-BD962F6411CE@.microsoft.com...
>I cannot forward pdf attachments that were created via daily scheduling
> within outlook web access. This does not seem to occur with manually
> attached pdfs that were created via Reporting Services or from within
> regular
> outlook. This leads me to believe there is something funky with the WAY
> the
> attachment is done in daily schedules. Please Advise.
> Thanks,
> Scott Eguires