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)