Thanks for your help its much appreciated

Thanks for your reply, can this be done even with SQL standard edition already installed on the server?

Thanks very much that helps alot.

Would you happen to know if i have a x64 server with standard edition on it currently and we want to use it for another...

thanks i backed up the transaction log then preformed the shrink. Nothing seems to work. But i have now set up trn jobs to back them up so hopefully this...

Thanks for your reply sorry for the late response i have been off work. I do this and when i try to reduce the log files to autogrow and no...

Thanks for your reply. We have backups in place and the log file doesnt grow more to than 3mb when sql was installed someone set it to 4gb but we...

Thanks very much thats brilliant ta

Hi

There is no error unfortunately it just stops the other log shipping stating it is out of sync.

Thanks

Hi yes the logs are being written correctly, only one of the restore jobs runs the other always fails as soon as i set it up, they have the same...

Yes they are completely different names although i do tell it to go to the same Y drive but it seems to store them in different places but still on...

Sorry! I should have said production and disaster recovery. I managed to fix it by logging in as sqlservice user

thanks

Thanks for the advice really appreciated

I think our application team enabled the T/Log job which ran every 15mins but i was unaware of it being enabled and also didnt realise this would affect the log...

ok fair enough thanks for the reply maybe i just expect too much 😀

Thanks i will check this out