Once again thanks, that has worked a treat. Think im going to see if it can date stamp the output that is created so that more than one file...

Thanks for this,

sorry for the delayed reply.

i will give this ago. the script will need to reference more than one DB but i assume i will be...

No i checked what it uses to run looking within services and checking what the service is running as.

Also i have not run the profiler as im not 100% sure...

The backup software is runing as domain\administrator, this user is added to SQL within the Security and looking at the server roles it is a member of Public and Sysadmin

I...

OK, thanks for the info. Any ideas where else i should be looking for receiving the following error during a backup window. We are using Veritas / Symantec...

Sorry i was refering to the sys.sysaltfiles when looking in the database at these then right clicking and selecting properties nothing is displayed in the Permissions

I was wondering if anything...

Hello

Thanks for this, i have now found these files. I have no permissions set on these. What would be the recommended ones to set?

Thanks in advance

Gareth

you say to find the sys.sys files. How do i find those files??

Hello

How i can check what permissions are on the sys.sysaltfiles files?

many thanks

Gareth

Thanks for this... I think im going to use the option within the right click, All Tasks, Shrink Database to set a schedule for the shrinking.

Any one come accross...

Hi

thanks for this

The reason that the DB's are growing is just the lack of disk space and not having the finance to buy more.

So there is a option in a...