Forum Replies Created

Viewing 15 posts - 241 through 255 (of 307 total)

  • RE: restoring a differntial backup

    Get out of EM.!!!!

    From BOL

    B. Restore a full database and a differential backup

    This example restores a full database backup followed by a differential backup restore. In addition, this...

  • RE: Transfer SP

    This probably more than what you are looking for, but it explains my reasoning. I like DTS it's a great tool, but I prefer to script changes and then apply...

  • RE: Choice between cluster, log shipping and repl.

    Based on your equipment, performance needs, and allowable downtime, your best best bet would be clustering. That doesn't come easy from me, I like log shipping. But If I was...

  • RE: database Suspend!

    6450 are good servers, my problem was on a 4400. Is there anything in the eventlog suggesting a hardware problem? Did you run any of the DELL diagnostic utilities?...

  • RE: spool sql logs to event viewer

    Ok I'm confused.

    On the database server open up Event viewer, under Security, look for failure audit you should see failed attempts to login, such as:

    1/22/2003 11:18:58 AM Security Failure...

  • RE: database Suspend!

    I was more interested in the brand and controllers. I had a similar experience on a Dell server. Ended up being batteries that needed to be scrubbed, more of a...

  • RE: Transaction logs increased up to 16 GB

    First off there's a lot of good advice that was given, and I don't hold a candle to Steven Jones, but that said it looks like you need a lesson...

  • RE: Transaction logs increased up to 16 GB

    First off there's a lot of good advice that was given, and I don't hold a candle to Steven Jones, but that said it looks like you need a lesson...

  • RE: Log shipping failures

    That always works.

    Just a note, your frequency setting for restoring the logs has to work around the time that your reports are running. Remember that in order to restore...

  • RE: Log shipping failures

    Please post your restore statement

    John Zacharkan

  • RE: Log shipping failures

    Has log shipping been establish and running or is this a new setup for you?

    John Zacharkan

  • RE: spool sql logs to event viewer

    Looking to get shot by the NT Admin are we?

    John Zacharkan

  • RE: SQL Source Control software?

    You must read Steve Jones 4 part series. I'm providing the link to the 4th part in the series which will link you to the other 3 parts http://www.sqlservercentral.com/columnists/sjones/vcspart4.asp

    Then follow...

  • RE: database Suspend!

    What is your hardware platform?

    John Zacharkan

  • RE: Check File Date??

    try some redirection like

    dir somefile /O > temp.txt

    The /O switch places among other things the date the file was created.

    Now look in the...

Viewing 15 posts - 241 through 255 (of 307 total)