Viewing 15 posts - 1,351 through 1,365 (of 4,745 total)
it says what it looks like, backup has completed for the last three nights.
Are you purging backup history older than 3 days?
---------------------------------------------------------------------
November 28, 2011 at 3:27 am
I'm aware of the process being used on standard clusters
of course another option might be to remove or evict the new node from the cluster and re-do it correctly.....:-)
---------------------------------------------------------------------
November 25, 2011 at 12:49 pm
awp (11/25/2011)
Thanks again, but I have to move them as they are on theSame disk as well, what are the risks when moving the system
Db's.
If it goes wrong...
---------------------------------------------------------------------
November 25, 2011 at 12:33 pm
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...
---------------------------------------------------------------------
November 25, 2011 at 10:51 am
by shut down the passive node I believe jeffrey means pause the node via cluster manager
---------------------------------------------------------------------
November 25, 2011 at 10:18 am
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.
---------------------------------------------------------------------
November 25, 2011 at 10:15 am
no need to apologise for incorrect assumptions, I just felt you weren't taking the information on-board.
---------------------------------------------------------------------
November 25, 2011 at 4:51 am
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...
---------------------------------------------------------------------
November 25, 2011 at 4:16 am
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...
---------------------------------------------------------------------
November 25, 2011 at 4:07 am
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...
---------------------------------------------------------------------
November 25, 2011 at 3:46 am
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...
---------------------------------------------------------------------
November 25, 2011 at 3:33 am
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.
---------------------------------------------------------------------
November 24, 2011 at 6:56 am
sorry just reread your post, if the E drive is going completely not to be replaced, its a reinstall
---------------------------------------------------------------------
November 24, 2011 at 6:47 am
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...
---------------------------------------------------------------------
November 24, 2011 at 6:45 am
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...
---------------------------------------------------------------------
November 24, 2011 at 3:17 am
Viewing 15 posts - 1,351 through 1,365 (of 4,745 total)