I know I'm not answering the question you posted but do you have spare disk capacity on another server?  If you do and your SQL Server Service is running under...

You are aware that if you change the recovery mode from FULL to Simple that you will not be able to backup the transaction logs?

If you have a disaster you...

It might be worth checking the File growth properties of the database. 

The data and logs should ideally be set to Autogrow by 10%.  If your database is set to...

Thanks for the advice.

I am aiming to turn the audit of successful logins off.

Just so you know.  It seems to be a DTS package that loops via an Active X script...

Thanks for the advice/information.

I was toying with the idea of recycling the Error Log as the Job has to run another 2 times today.  I am going to change the audit...

Thanks again Greg

Regards

Carl

Thanks Greg,

So if we have an MSDN Universal subscription we can utilise the SQL Server Developer Edition for our test environment without any further cost ?

Carl

Apologies.

I am not very well up on Licencing as it's not an issue I have had to control in my passed roles.

I have read that SQL Server 2000 Developer Edition...

Not sure what you mean?

I actually implemented the following last night and it seemed to job the job when I checked this morning:

I have 1 'on success' line that goes...

Once I have changed the recovery mode to simple; I can just do a backup log with truncate only to clear down the space used in the tran log can't...

Cheers Frank,

I have read that it sets a registry setting but wasn't sure whether a top and restart was necessary.

Carl

Brian,

Thanks again for your advice.

So if you don't necessarily need network access for backups or outputting of reports to File Severs the best way is a local account.

If I use a...

Brian

Thanks for the information about the local system account permissions.  I can see why Microsoft advise against using this account now.  The only other question I have got is

Is...

A starter for 10 would be to generate scripts for all tables in the database to a text file.

You can do this by right clicking the database and choosing generate SQL...

Hi,

I've just checked this error in google and found the following response on a site to the error message you are getting.

Seems like xpstar.dll is being deleted from the server...