Forum Replies Created

Viewing 15 posts - 1,351 through 1,365 (of 4,745 total)

  • RE: Backup failure

    it says what it looks like, backup has completed for the last three nights.

    Are you purging backup history older than 3 days?

    ---------------------------------------------------------------------

  • RE: node added to cluster w/o SP4 Version=RTM Resource DB SP4

    I'm aware of the process being used on standard clusters

    http://sqlblog.com/blogs/linchi_shea/archive/2009/10/04/pause-the-passive-node-to-apply-sql2005-service-pack-or-hotfix.aspx

    of course another option might be to remove or evict the new node from the cluster and re-do it correctly.....:-)

    ---------------------------------------------------------------------

  • RE: moving database files to another disk

    awp (11/25/2011)


    Thanks again, but I have to move them as they are on the

    Same disk as well, what are the risks when moving the system

    Db's.

    If it goes wrong...

    ---------------------------------------------------------------------

  • RE: node added to cluster w/o SP4 Version=RTM Resource DB SP4

    pausing the node was how I last applied a patch to a multi site cluster, see here

    Its a workaround for when a SQL 2005 patch fails to apply to all...

    ---------------------------------------------------------------------

  • RE: node added to cluster w/o SP4 Version=RTM Resource DB SP4

    by shut down the passive node I believe jeffrey means pause the node via cluster manager

    ---------------------------------------------------------------------

  • RE: moving database files to another disk

    This is the process for moving system databases at SQL2005

    tempdb is the easiest and safest to move, personally I avoid moving the other system databases unless I really have to.

    ---------------------------------------------------------------------

  • RE: Restoring a COPY_ONLY backup

    no need to apologise for incorrect assumptions, I just felt you weren't taking the information on-board.

    ---------------------------------------------------------------------

  • RE: Restoring a COPY_ONLY backup

    adb2303 (11/25/2011)


    i'm not ignoring the answers. I specifically take copy_only backups because I don't want to interfere with log backups! I think there's some wires crossed here.

    I said...

    ---------------------------------------------------------------------

  • RE: Restoring a COPY_ONLY backup

    hit the books.

    A full backup DOES NOT truncate the transaction log, therefore you can restore a log through a full backup.

    i.e.

    full backup 1

    log backup 1

    log backup 2

    full backup 2

    log backup...

    ---------------------------------------------------------------------

  • RE: Restoring a COPY_ONLY backup

    I take the copy_only backup because I don't want my 15 min trans log backups to be based on my adh-hoc support full backup...

    thanks,

    why post and ignore the answers?

    copy_only...

    ---------------------------------------------------------------------

  • RE: Restoring a COPY_ONLY backup

    use the 'from device' radio button and navigate to the location of your backup to select the backup you want to restore.

    Note just in case - you only need to...

    ---------------------------------------------------------------------

  • RE: Moving "E:\Program Files\Microsoft SQL Server\90\Tools"

    Reinstall.

    But why is the E drive dying? You would actually be better off moving your system databases from the C to the E in terms of best practice configuration.

    ---------------------------------------------------------------------

  • RE: Moving "E:\Program Files\Microsoft SQL Server\90\Tools"

    sorry just reread your post, if the E drive is going completely not to be replaced, its a reinstall

    ---------------------------------------------------------------------

  • RE: Moving "E:\Program Files\Microsoft SQL Server\90\Tools"

    could you move all the contents of the current E drive to the new drive, then re-label the new drive as the E? SQL would need to be stopped.

    Otherwise its...

    ---------------------------------------------------------------------

  • RE: which High Avaiblity Option is better?

    please when giving extra info that has been requested do it by adding another post rather than editing your original post. People only get notified you have replied when you...

    ---------------------------------------------------------------------

Viewing 15 posts - 1,351 through 1,365 (of 4,745 total)