The Error Log time is ;

1. The Time when SQL server was last re-started.

2. The time when the SQL Log was recycled.

Details are here

DBCC CHECKDB reports inconsistencies if any. Details are here

Hi Desmond,

Please post the error message that you are getting when you try to start the services. You can get the information from the System Event log and the SQL...

Maintenance plans help you take backup of selected databases and automate it. Details are here. Look for "Set Up Backup Schedules (Maintenance Plan Wizard) "

2) Try changing the "Owner" of the job to the Account which has permissions on the remote share.

Hi Ashwin,

1. Just try this

2. Make sure that the SQL Server Agent start up account and the owner of the job...

This thread may help you.

Adiga (3/17/2009)

---

It depends on how to schedule the backup.

1. If a Maintenance plan is set up for it, deleting it would stop the job.

2. If a SQL Server job is...

It depends on how to schedule the backup.

1. If a Maintenance plan is set up for it, deleting it would stop the job.

2. If a SQL Server job is set...

This [/url]script might work for you.

It had also mentioned about checking the "Database growth" settings. Please check the same on the Database in question and the tempdb.

You cannot restore a SQL Server 2005 database backup to SQL Server 2000.

Hi Ratheesh,

This [/url]script on SSC might do the trick for you.

Sometimes it takes that much time, depending on what it was doing before kill.

DBCC INPUTBUFFER(SPID) would tell you the current status.

Hi Ratheesh,

You are referring to "TEMPLOG" as the database instead of "TEMPDB". Change it to TEMPDB and everything will be...