Backup the MSDB database.

Or

Open Enterprise Manager, expand Management, expand SQL Server Agent. Click on Jobs. Right click on a job, select All Tasks > Generate SQL Script.

Either way will work,...

Yes and no. Gail pointed out one view point. But transaction log and log file are also used interchangably in SQL Server. The transaction log file is...

What DID both of them return? Also, how many instances do you have on the server?

-SQLBill

Michael,

Autostart in that context only occurs when the server is started. Then SQL Server Agent will autostart.

I believe the poster's problem is that when you just stop the services (MSSQLServer...

Basically, NULL means 'I don't know what this value is'. If you don't know what the value is, how can you compare it (, =, =>, =<, etc) to...

Yes??????????

Is the tape drive internal or external? If external, was it added after SQL Server was installed? Have you rebooted the server?

-SQLBill

I like http://www.tek-tips.com. It is for Computer Professionals and has a forum for almost anything to do with the IT world.

-SQLBill

One of the big decisions that has to be made when setting up a database is: how important is the data? How important is it for me to be...

Okay. Lets say you do your daily backups at 10 PM, log backups every 4 hours (4 am, 8 am, noon, 4 pm, 8 pm, midnight). And you do...

If the database is in SIMPLE mode you can't do a log backup.

Log backups ONLY apply to the previous Full Backup. You should be doing EITHER daily or weekly...

Why are you doing this? Just set the SQL Server Agent service to automatically start. It's dependent on the SQL Server service, so the agent one won't start until...

A copy of the index will still be made. If the reindexing is stopped before it finishes, it has to be able to rollback all the changes. So the...

No. Not for a basic update like that. Primary/Foreign keys are for when you are inserting data and you need to maintain integrity of the data. You...

Is the 'new' CalcAction based on the TransactionCounts_Sort.SortOrder or the TransactionCounts_Sort.ID?

What do you want to have happen with the second Record Count by Status row?

Something like:

UPDATE TransactionCounts

SET TransactionCounts.CalcAction =...