Forum Replies Created

Viewing 15 posts - 256 through 270 (of 2,487 total)

  • RE: does SQL 2005 allow log shipping between 2 instances

    Ahhh ... you'll need to post the images to on of the many photo sharing websites and then post the urls for us to see the images.

    --------------------
    Colt 45 - the original point and click interface

  • RE: does SQL 2005 allow log shipping between 2 instances

    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...

    --------------------
    Colt 45 - the original point and click interface

  • RE: does SQL 2005 allow log shipping between 2 instances

    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...

    --------------------
    Colt 45 - the original point and click interface

  • RE: I need some assistance

    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...

    --------------------
    Colt 45 - the original point and click interface

  • RE: does SQL 2005 allow log shipping between 2 instances

    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...

    --------------------
    Colt 45 - the original point and click interface

  • RE: Minimizing Transaction Log Disk Space Usage

    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...

    --------------------
    Colt 45 - the original point and click interface

  • RE: Impossible to catch error for : Cannot insert duplicate key row in object .......

    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...

    --------------------
    Colt 45 - the original point and click interface

  • RE: Impossible to catch error for : Cannot insert duplicate key row in object .......

    I don't know about anyone else, but I'm eagerly awaiting this piece of code.

    Please post it quickly.

    --------------------
    Colt 45 - the original point and click interface

  • RE: Verifying SQL server backups - how do I tell if they failed

    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...

    --------------------
    Colt 45 - the original point and click interface

  • RE: sql 2000 log shipping problems

    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...

    --------------------
    Colt 45 - the original point and click interface

  • RE: Blackberrys

    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...

    --------------------
    Colt 45 - the original point and click interface

  • RE: Script of the day

    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,...

    --------------------
    Colt 45 - the original point and click interface

  • RE: Subscription - Username can be seen but is not correct

    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...

    --------------------
    Colt 45 - the original point and click interface

  • RE: Blackberrys

    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...

    --------------------
    Colt 45 - the original point and click interface

  • RE: Compress backup files

    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,...

    --------------------
    Colt 45 - the original point and click interface

Viewing 15 posts - 256 through 270 (of 2,487 total)