Viewing 15 posts - 256 through 270 (of 2,486 total)
So you're running this via maintenance plans? Right-click on the maintenance plans folder and choose view history. For some reason MS thought they'd hide this away seperate from the SQL...
June 26, 2007 at 1:35 am
If you post the error messages that are received when you're setting up the log shipping, we could maybe suggest what needs to change so that you can get it...
June 25, 2007 at 11:26 pm
I'd remove all the "SQL" related entries.
You can also check the Windows Event log to see what application is issuing that error. Have you previously installed an application that uses...
June 25, 2007 at 9:29 pm
Yes you can log ship between instances.
If the inbuilt Log Shipping doesn't work, then put together your own scripts to backup and restore. There's probably some usable scripts in the...
June 25, 2007 at 9:25 pm
I would be doing transaction log backups more frequently and not continually shrink the log file.
If the log file is continually growing then obviously it's not large enough to...
June 25, 2007 at 9:22 pm
Dave, I don't think this is a batch termination problem. James has posted a couple of example that catch the error without any problems.
My thought is there is some sort...
June 20, 2007 at 5:41 am
I don't know about anyone else, but I'm eagerly awaiting this piece of code.
Please post it quickly.
June 20, 2007 at 1:07 am
Generally you should have some sort of email notification setup, whether it's using SQL Mail and Outlook, CDO or something like XPSMTP. Then when a job thats running a backup...
June 19, 2007 at 5:54 pm
So change the server account to a domain account and it should be right.
Personally I don't use the maintenance plans for log shipping. Too many points were things like this...
June 15, 2007 at 10:06 pm
Just forward your complaints on to Blackberry. I mean a PDF is a PDF is a PDF right? Not if you're viewing on the Blackberry, then it's a mangled bit...
June 15, 2007 at 8:17 am
I'm sure Steve has plenty of time to test all the scripts that are submitted
Seriously though, if it's that much of an issue,...
June 14, 2007 at 7:19 pm
Check the ReportServer config file. There is a default domain setting that you can use which will be appended to the username if the one is not supplied in the...
June 14, 2007 at 7:12 pm
The Blackberry Enterprise Server does weird things to attachments. Even a stock standard PDF was thouroughly mangled and almost unreadable.
Best looking solution we came up with was a html email...
June 14, 2007 at 7:09 pm
We've made extensive use of GZip (http://www.gxip.org) at many of our client sites. Haven't had any issues as yet. Does tend to churn a bit when thrown a mulit-gigabyte file,...
June 14, 2007 at 6:39 pm
You can do it with a global variable, but the trick is that the query has to follow Progress syntax, not T-SQL syntax. From memory we used a date format...
June 14, 2007 at 6:28 pm
Viewing 15 posts - 256 through 270 (of 2,486 total)