SQL Agent Service will not start
From: Peter the Spate (anonymous_at_discussions.microsoft.com)
Date: 08/04/04
- Next message: Steve Kass: "Re: Best way to Import data from EXCEL using a TSQL"
- Previous message: Vikram Jayaram [MS]: "RE: why inconsistency errors on msdb again?"
- In reply to: Jamil Ahsan: "SQL Agent Service will not start"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 4 Aug 2004 09:23:16 -0700
To get a smaller log file
1. Right click on the database, select option tab
2. In the Recovery model dropdown change the model
to 'Simple' and press ok
3. Right click on the database select All Tasks, Shrink
Database, remember to put the free space to 10%.
4. Change the recovery model back to it was before.
As for your SQL Agent
1. Under management Right click on SQL Server Agent
2. Select Start.
if it doesn't then you will need to have a look at the log.
(SQL Server Agent -> Display error log.
Email me the error at peternolan67REMOVETHIS@hotmail.com
Peter
>-----Original Message-----
>Hi All,
>
>I am fairly new to SQL. I will appreciate if you guys can
help me out to resolve following two isuues.
>
>How can I shrink database.ldf size? My database is only
650MB but log size is 8GB.
>Secondly when I setup log shipping, it worked for a day
and then SQL agent service stopped responding and will not
start at all.
>
>Thanks in advance for your help.
>
>Regards,
>
>Jamil
>.
>
- Next message: Steve Kass: "Re: Best way to Import data from EXCEL using a TSQL"
- Previous message: Vikram Jayaram [MS]: "RE: why inconsistency errors on msdb again?"
- In reply to: Jamil Ahsan: "SQL Agent Service will not start"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
