So hold on - are we saying that SQL has no native way of outputting data to a text file and appending the data? Is it just me or is...

Hi

I trialled both these products (and others) recently and have just purchased the Redgate product as backup sizes were becoming an issue on some of our servers. The compression rates...

Ah - thanks Bert, it does just what I need.

cheers

Gordon

The failover messages are written to the event log so anything that can report on that would do the job for you. It depends how much you want to spend...

Thanks for that. Our DR involves rebuilding servers for scratch, hence to the need to restore master, then msdb, then user databases.

I'll be teting out a SQL 7 master Litespeed...

Thanks, I'll download and try it. I'm still interested to know about the master restore limitation of Litespeed though......

I had the same problem where a DBCC SHRINKFILE command said it couldn't locate the entries in sysfiles even though they were there. Couldn't find a logical reason why but a stop...

It's pretty much me that manages the server! I don't think it's a SQL permission issue as I can execute the xp_loginconfig procedure fine - it's only when I'm trying...

Perfect! Exactly what I was looking for.

Thanks

Thanks Nicholas - I see what you mean. However if the job and steps have had their names changed it doesn't match. I was also hoping for a more automatic...

Thanks Mike

My domain account is a sysadmin within SQL and the local startup account is a local admin so permissions shouldn't be an issue.

SQL logins will certainly work however...

@@PROCID will return the id of the current stored procedure. You can then look this id up in the sysobjects table to find the procedure name.

regards

Thanks, it was a server alias.

We use dbcc sqlperf (logspace) to return the size of all the log files on the server.

You could schedule this to run each morning or at intervals throughout the day....

Thanks for all the replies. Would you believe it "results in grid" was causing the problem. Sometime you look so hard the answer is staring you in the face.

cheers