Easiest approach is to use SQLCMD.exe on server A to connect to Server B and then use a backup script in SQLCMD.

This can be scheduled using a SQL Server Agent...

Is the SQL Server service started? You can check it in "SQL Server Configuration Manager"

Job Activity Monitor is not available in SQL Server 2000.

Like John mentioned for the second you need to get...

I am not aware of any such issues. All the production instances in my environment are running on SP3 +

What is the job designed to do? Also try adding an output file to the Job Step. It gives you the complete logging of the job.

If...

Regarding the restore error, please run RESTORE HEADERONLY FROM DISK='YourFileName'. This would give you the database name to which the backup file belongs to.

But I feel it would be better...

@vamshikrishnaeee,

To reduce the number of VLFs the easy approach is to

1) Take the transaction log backup

2) Shrink the transaction log to the minimum size possible

3) Increase the transaction log file...

Check if these scripts help

http://www.sqlservercentral.com/scripts/Miscellaneous/31859

http://www.mssqltips.com/tip.asp?tip=1555

Here[/url] is a good one in SSC.

How are you starting the SQL Server Agent for this instance?

Do you see this error every time you try to start Agent?

If this is a recurring error please go through...

@matthew.lau,

I am not aware of any such tools. You can try this method in sqlcmd or osql.

SET PARSEONLY ON

go

<YourQuery>

SET PARSEONLY OFF

go

Phil Parkin (11/25/2010)

Adiga (11/25/2010)

However it looks like the SQL Server Agent startup account does not have access to the path specified. Can you double check if the SQL Server Agent...

However it looks like the...

AFAIK, sqlcmd and osql do not have the ability to do syntax check.